Fwd to dev. Best, Yingyi
---------- Forwarded message ---------- From: Willy Aguirre (JIRA) <j...@apache.org> Date: Wed, Feb 1, 2017 at 3:24 PM Subject: [jira] [Commented] (ASTERIXDB-1327) Spatial-intersect between point and circle not working correctly To: notificati...@asterixdb.incubator.apache.org [ https://issues.apache.org/jira/browse/ASTERIXDB-1327? page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel& focusedCommentId=15849105#comment-15849105 ] Willy Aguirre commented on ASTERIXDB-1327: ------------------------------------------ Hello! I am new in AsterixDB I would like to work in this ticket. could you help me? please I made a repo with my examples https://github.com/marti1125/understanding_asterixdb > Spatial-intersect between point and circle not working correctly > ---------------------------------------------------------------- > > Key: ASTERIXDB-1327 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-1327 > Project: Apache AsterixDB > Issue Type: Bug > Reporter: Steven Jacobs > Assignee: Jianfeng Jia > Attachments: EmergencyReports.adm, UserLocationsShort.adm > > > The first query returns a large set of results. The second returns nothing > {noformat} > for $report in dataset EmergencyReports > for $location in dataset UserLocations > where $report.emergencyType = "earthquake" > let $circle := create-circle($location.location,.1) > where spatial-intersect($report.impactZone, $circle) > return { > "user at":$location.location, > "report at":$report.impactZone > } > {noformat} > {noformat} > for $report in dataset EmergencyReports > for $location in dataset UserLocations > where $report.emergencyType = "earthquake" > where spatial-intersect($report.impactZone, $location.location) > return { > "user at":$location.location, > "report at":$report.impactZone > } > {noformat} > Here are the DDL statements. I will attach the two datasets: > {noformat} > drop dataverse channels if exists; > create dataverse channels; > use dataverse channels; > create type UserLocation as closed { > recordId: uuid, > location: point, > user-id: string, > timeoffset: float > } > create type EmergencyReport as closed { > reportId: uuid, > severity: int, > impactZone: circle, > timeoffset: float, > duration: float, > message: string, > emergencyType: string > } > create dataset UserLocations(UserLocation) > primary key recordId autogenerated; > create dataset EmergencyReports(EmergencyReport) > primary key reportId autogenerated; > load dataset UserLocations using localfs (("path"="asterix_nc1:/// Users/stevenjacobs/Desktop/EmergencyDataset/UserLocationsShort.adm"),(" format"="adm")); > load dataset EmergencyReports using localfs(("path"="asterix_nc1:/ //Users/stevenjacobs/Desktop/EmergencyDataset/EmergencyReports.adm"),(" format"="adm")); > {noformat} -- This message was sent by Atlassian JIRA (v6.3.15#6346)