asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Willy Aguirre (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ASTERIXDB-1327) Spatial-intersect between point and circle not working correctly
Date Wed, 01 Feb 2017 23:24:51 GMT

    [ 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)

Mime
View raw message