| 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 $c.age < 21 |
| return {"cust":$c.name, "custage": $c.age, "ordertot":$o.total} |