| drop dataverse test if exists; |
| create type LineItemType as closed { |
| create dataset LineItem(LineItemType) |
| partitioned by key l_orderkey, l_linenumber; |
| using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" |
| (("path"="nc1://data/tpch0.001/lineitem.tbl"),("format"="delimited-text"),("delimiter"="|")) pre-sorted; |
| create index idx_LineItem_partkey on LineItem(l_linenumber); |
| create index idx_LineItem_suppkey on LineItem(l_suppkey); |
| delete $l from dataset LineItem where $l.l_suppkey>=2 or $l.l_linenumber>1; |
| write output to nc1:"rttest/dml_delete-from-loaded-dataset-with-index.adm"; |
| for $c in dataset('LineItem') |
| order by $c.l_orderkey, $c.l_linenumber |