| declare type CustomerType as open { |
| declare type AddressType as open { |
| declare type OrderType as open { |
| declare nodegroup group1 on rainbow-01, rainbow-02, rainbow-03, rainbow-04, rainbow-05; |
| declare dataset Customers(CustomerType) |
| partitioned by key cid on group1; |
| declare dataset Orders(OrderType) |
| partitioned by key oid on group1; |
| write output to rainbow-01:"/home/onose/hyracks-rainbow/results/custorder.adm"; |
| for $c in dataset('Customers') |
| for $o in dataset('Orders') |
| where $c.cid = $o.cid and $o.total > 70 |
| group by $age := $c.age with $c |
| return {"custage": $age, "count":count($c)} |