| use dataverse demo_aql; |
| |
| declare type CustomerType as open { |
| cid: int32, |
| name: string, |
| age: int32?, |
| address: AddressType?, |
| interests: {{string}}, |
| children: [ { name: string, age: int32? } ] |
| } |
| |
| declare type AddressType as open { |
| number: int32, |
| street: string, |
| city: string |
| } |
| |
| declare nodegroup group1 on rainbow-01, rainbow-02, rainbow-03, rainbow-04, rainbow-05; |
| |
| declare dataset Customers(CustomerType) |
| partitioned by key cid on group1; |
| |
| write output to rainbow-01:"/home/onose/hyracks-rainbow/results/03-count-cust-age.adm"; |
| |
| count( |
| for $c in dataset('Customers') |
| where not(is-null($c.age)) |
| return $c |
| ) |