blob: c239185d4e058b1fc05cb68b18962f3e4787386f [file] [log] [blame]
drop dataverse test if exists;
create dataverse test;
use dataverse test;
create type MyRecord as open {
id: int32,
point: point,
kwds: string
}
create external dataset MyData(MyRecord)
using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
(("path"="nc1://data/spatial/spatialData.json"),("format"="adm"));
write output to nc1:"rttest/spatial_point-in-polygon.adm";
for $o in dataset('MyData')
where spatial-intersect($o.point, $o.poly1)
order by $o.id
return {"id":$o.id}