| use dataverse demo_aql; | |
| declare type OrderType as open { | |
| oid: int32, | |
| cid: int32, | |
| orderstatus: string, | |
| orderpriority: string, | |
| clerk: string, | |
| total: float | |
| } | |
| declare nodegroup group1 on rainbow-01, rainbow-02, rainbow-03, rainbow-04, rainbow-05; | |
| declare dataset Orders(OrderType) | |
| partitioned by key oid on group1; | |
| write output to rainbow-01:"/home/onose/hyracks-rainbow/results/05-count-param1.adm"; | |
| count( | |
| for $o in dataset('Orders') | |
| where not(is-null($o.param1)) | |
| return $o | |
| ) |