drop dataverse tpch if exists; | |
create dataverse tpch; | |
use dataverse tpch; | |
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/push_limit.adm"; | |
for $o in dataset('Orders') | |
where $o.o_totalprice > 100 | |
order by $o.o_orderkey | |
limit 10 offset 5 | |
return { "price": $o.o_totalprice, "date": $o.o_orderdate } | |