| drop dataverse test if exists; |
| create dataverse test; |
| use dataverse test; |
| |
| create type OrderType as open { |
| oid: int32, |
| cid: int32, |
| orderstatus: string, |
| orderpriority: string, |
| clerk: string, |
| total: float |
| } |
| |
| create external dataset Orders(OrderType) |
| using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" |
| (("path"="nc1://data/semistructured/tiny01/orders.adm"),("format"="adm")); |
| |
| write output to nc1:"rttest/semistructured_has-param1.adm"; |
| |
| for $o in dataset('Orders') |
| where not(is-null($o.param1)) |
| order by $o.oid |
| return $o |