blob: 7939fed6ec16ee1d0c21cac725a8b41063ba6c99 [file] [log] [blame]
drop dataverse prim_index_search if exists;
create dataverse prim_index_search;
use dataverse prim_index_search;
create type OrderType as closed {
o_orderkey: int32,
o_custkey: int32,
o_orderstatus: string,
o_totalprice: double,
o_orderdate: string,
o_orderpriority: string,
o_clerk: string,
o_shippriority: int32,
o_comment: string
}
create nodegroup group1 if not exists on nc1, nc2;
create dataset Orders(OrderType)
primary key o_orderkey on group1;
write output to nc1:"/tmp/prim_index_search.adm";
for $o in dataset('Orders')
where
$o.o_orderkey = 34
return {
"o_orderkey": $o.o_orderkey,
"o_custkey": $o.o_custkey
}