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, | |
items: [int32] | |
} | |
create external dataset Orders(OrderType) | |
using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" | |
(("path"="nc1://data/nontagged/orderData.json"),("format"="adm")); | |
write output to nc1:"rttest/custord_order_q_01.adm"; | |
for $c in dataset('Orders') | |
return $c |