use dataverse demo0927; | |
declare type CustomerType as closed { | |
cid: int32, | |
name: string, | |
age: int32?, | |
address: AddressType?, | |
lastorder: { | |
oid: int32, | |
total: float | |
} | |
} | |
declare type AddressType as closed { | |
number: int32, | |
street: string, | |
city: string | |
} | |
declare nodegroup group1 on nc1, nc2; | |
declare dataset Customers(CustomerType) | |
partitioned by key cid on group1; | |
for $c in dataset('Customers') | |
return $c | |
// { "custname":$c.name } | |