| vinayakb | 38b7ca4 | 2012-03-05 05:44:15 +0000 | [diff] [blame^] | 1 | use dataverse demo_aql; |
| 2 | |||||
| 3 | declare type OrderType as open { | ||||
| 4 | oid: int32, | ||||
| 5 | cid: int32, | ||||
| 6 | orderstatus: string, | ||||
| 7 | orderpriority: string, | ||||
| 8 | clerk: string, | ||||
| 9 | total: float | ||||
| 10 | } | ||||
| 11 | |||||
| 12 | declare nodegroup group1 on nc1, nc2; | ||||
| 13 | |||||
| 14 | declare dataset Orders(OrderType) | ||||
| 15 | partitioned by key oid on group1; | ||||
| 16 | |||||
| 17 | write output to nc1:"/tmp/05-count-param1.adm"; | ||||
| 18 | |||||
| 19 | count( | ||||
| 20 | for $o in dataset('Orders') | ||||
| 21 | where not(is-null($o.param1)) | ||||
| 22 | return $o | ||||
| 23 | ) | ||||