blob: 6dab8098d420b1dbafacc028e403a141d801bbe1 [file] [log] [blame]
drop dataverse test if exists;
create dataverse test;
use dataverse test;
create type MyRecord as closed {
id: int32,
point: point,
kwds: string,
line1: line,
line2: line,
poly1: polygon,
poly2: polygon,
rec: rectangle
}
create dataset MyData(MyRecord)
partitioned by key id;
load dataset MyData
using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
(("path"="nc1://data/spatial/spatialData.json"),("format"="adm"));
create index rtree_index_point on MyData(point) type rtree;
write output to nc1:"rttest/index_rtree-secondary-index.adm";
for $o in dataset('MyData')
where spatial-intersect($o.point, create-polygon(create-point(4.0,1.0), create-point(4.0,4.0), create-point(12.0,4.0), create-point(12.0,1.0)))
order by $o.id
return {"id":$o.id}