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_line-intersect-line.adm"; | |
for $o in dataset('MyData') | |
where spatial-intersect($o.line1, $o.line2) | |
order by $o.id | |
return {"id":$o.id} | |