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_circle-intersect-circle.adm";

for $o in dataset('MyData')
where spatial-intersect(create-circle(create-point(0.0,0.0), 5.0), create-circle(create-point(9.9,0.0), 5.0))
order by $o.id
return {"id":$o.id}