blob: eda401556b7107515137445899a4bfc46936b33e [file] [log] [blame]
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
)