Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [geomesa-users] Geomesa 1.1.0-rc2 temporal query question
Hi Ben,

I'd give clone the repo using Git the nod.  If you do that, we may be able to work through either new commits to master or a branch to address any issues as they come up.  Also, since you've been learning Scala, having a Git checkout will make it easier to contribute back fixes or documentation updates;).

Thanks,

Jim

On 02/04/2016 11:13 AM, Ben Southall wrote:

Yep, I’ll try 1.2.0-SNAPSHOT

 

Do you recommend tracking the master from github, or should I pick up the tar.gz from the link on geomesa.org (https://github.com/locationtech/geomesa/archive/master/1.x.tar.gz)?

 

Thanks,

 

Ben

 

From: geomesa-users-bounces@xxxxxxxxxxxxxxxx [mailto:geomesa-users-bounces@xxxxxxxxxxxxxxxx] On Behalf Of Jim Hughes
Sent: Thursday, February 04, 2016 10:40 AM
To: geomesa-users@xxxxxxxxxxxxxxxx
Subject: Re: [geomesa-users] Geomesa 1.1.0-rc2 temporal query question

 

Hi Ben,

Thanks for the output from the 'describe' command.  There could have been an issue with having two different dates in the SimpleFeatureType.  Since that's the not the case, it looks like we have a bug here.

If you are willing to try out the top of master (1.2.0-SNAPSHOT), we'll respond as immediately as possible since we're pushing for a release in the next week or two.

Thanks,

Jim

On 02/04/2016 10:12 AM, Ben Southall wrote:

Hi Jim,

 

Thanks for the quick response. Looks like observationTime is used by the Z3 index (at least that’s my interpretation of the following – which of course could be wrong):

 

mmsi: Long (Indexed)

latitude: Double

longitude: Double

observationTime: Date (ST-Time-index)

currentHeading: Float

currentSpeed: Double

trueHeading: Integer

geom: Point (ST-Geo-index) (Indexed)

 

I’ve been meaning to move along to 1.2, so perhaps I should just do that upgrade and try with a newer version.

 

Ben

 

From: geomesa-users-bounces@xxxxxxxxxxxxxxxx [mailto:geomesa-users-bounces@xxxxxxxxxxxxxxxx] On Behalf Of Jim Hughes
Sent: Tuesday, February 02, 2016 6:49 PM
To: geomesa-users@xxxxxxxxxxxxxxxx
Subject: Re: [geomesa-users] Geomesa 1.1.0-rc2 temporal query question

 

Hi Ben,

This one is good issue...  I checked out the indexing, and the date filter is not pass through since the Z3 index should be able to handle the temporal bounds fairly well.  I also checked out the release notes from 1.1.0-rc2 until now, and nothing jumped out at me. 

Is the observationTime attribute the one used by the Z3 index?  (You could find out a little bit about this via the GeoMesa 'describe' command line tool.) 

Thanks,

Jim

On 02/02/2016 03:39 PM, Ben Southall wrote:

Hello,

 

I’ve some interesting results using a spatio-temporal query with Geomesa 1.1.0-rc2. In short, it looks like the temporal section of the query is planned but not executed; records outside of the specified time range are returned.

 

The output of the query planner is below, and below that the output in response to the executed query (the format of that is ID, lon, lat, timestamp – the critical part is that you’ll notice that the final timestamp column has dates that go outside of the specified range of 2012-7-25 (UTC))

 

Any help appreciated as ever!

 

Thanks,

 

Ben

 

--

 

Planning Query: feature type: ais_report, filter: [[ geom intersects POLYGON ((110.190556 1.337222, 110.190556 1.837222, 110.690556 1.837222, 110.690556 1.337222, 110.190556 1.337222)) ] AND [ observationTime BETWEEN Tue Jul 24 20:00:00 EDT 2012 AND Wed Jul 25 19:59:59 EDT 2012 ]], [properties:  ALL ]

Original filter: [[ geom intersects POLYGON ((110.190556 1.337222, 110.190556 1.837222, 110.690556 1.837222, 110.690556 1.337222, 110.190556 1.337222)) ] AND [ observationTime BETWEEN Tue Jul 24 20:00:00 EDT 2012 AND Wed Jul 25 19:59:59 EDT 2012 ]]

Rewritten filter: [[ geom intersects POLYGON ((110.190556 1.337222, 110.190556 1.837222, 110.690556 1.837222, 110.690556 1.337222, 110.190556 1.337222)) ] AND [ observationTime BETWEEN Tue Jul 24 20:00:00 EDT 2012 AND Wed Jul 25 19:59:59 EDT 2012 ]]

Strategy: org.locationtech.geomesa.accumulo.index.Z3IdxStrategy

Transforms: None

Geometry filters: ArrayBuffer([ geom intersects POLYGON ((110.190556 1.337222, 110.190556 1.837222, 110.690556 1.837222, 110.690556 1.337222, 110.190556 1.337222)) ])

Temporal filters: ArrayBuffer([ observationTime BETWEEN Tue Jul 24 20:00:00 EDT 2012 AND Wed Jul 25 19:59:59 EDT 2012 ])

Other filters: ArrayBuffer()

Tweaked geom filters are ArrayBuffer([ geom intersects POLYGON ((110.190556 1.337222, 110.190556 1.837222, 110.690556 1.837222, 110.690556 1.337222, 110.190556 1.337222)) ])

GeomsToCover: GEOMETRYCOLLECTION (POLYGON ((110.190556 1.337222, 110.190556 1.837222, 110.690556 1.837222, 110.690556 1.337222, 110.190556 1.337222)))

Interval:  2012-07-25T00:00:00.000Z/2012-07-25T23:59:59.999Z

Transforms: None

Table: nrl_global_ais_ais_5freport_z3

Column Families (1): List(F)

Ranges (38): [%08;%ac;;%05;%a7;`%00;%00;%00;%00; : [] 9223372036854775807 false,%08;%ac;;%05;%a7;%80; : [] 9223372036854775807 false), [%08;%ac;;%05;%ae;%00;%00;%00;%00;%00; : [] 9223372036854775807 false,%08;%ac;;%05;%ae;%80; : [] 9223372036854775807 false), [%08;%ac;;%05;%b5;%00;%00;%00;%00;%00; : [] 9223372036854775807 false,%08;%ac;;%05;%b5;%80; : [] 9223372036854775807 false), [%08;%ac;;%05;%b7;%00;%00;%00;%00;%00; : [] 9223372036854775807 false,%08;%ac;;%05;%b7;%80; : [] 9223372036854775807 false), [%08;%ac;;%05;%bc;%00;%00;%00;%00;%00; : [] 9223372036854775807 false,%08;%ac;;%05;%bc;%80; : [] 9223372036854775807 false)

Iterators (1): [name:z3, priority:21, class:org.locationtech.geomesa.accumulo.iterators.Z3Iterator, properties:{zmax=4262022051406445999, zmin=4252989486794603692}]

Table: nrl_global_ais_ais_5freport_z3

Column Families (1): List(F)

Ranges (256): [%08;%ad;2%01;% %00;%00;%00;%00; : [] 9223372036854775807 false,%08;%ad;2%01;%%80; : [] 9223372036854775807 false), [%08;%ad;2%01;'%00;%00;%00;%00;%00; : [] 9223372036854775807 false,%08;%ad;2%01;'%80; : [] 9223372036854775807 false), [%08;%ad;2%01;,%00;%00;%00;%00;%00; : [] 9223372036854775807 false,%08;%ad;2%01;,%80; : [] 9223372036854775807 false), [%08;%ad;2%01;.%00;%00;%00;%00;%00; : [] 9223372036854775807 false,%08;%ad;2%01;.%80; : [] 9223372036854775807 false), [%08;%ad;2%01;5%00;%00;%00;%00;%00; : [] 9223372036854775807 false,%08;%ad;2%01;5%80; : [] 9223372036854775807 false)

Iterators (1): [name:z3, priority:21, class:org.locationtech.geomesa.accumulo.iterators.Z3Iterator, properties:{zmax=4262022051406445995, zmin=3603202024315597960}]

Query planning took 240 ms for 1 distinct queries.

 

==

533404000 110.449, 1.58492 2012-07-25T17:13:29.000-04:00

533404000 110.448, 1.5849 2012-07-25T19:07:08.000-04:00

567428000 110.509, 1.82599 2012-07-25T20:55:44.000-04:00

533404000 110.45, 1.58553 2012-07-25T22:18:09.000-04:00

567428000 110.51, 1.82607 2012-07-26T10:04:33.000-04:00

533000707 110.594, 1.73786 2012-07-26T13:32:55.000-04:00

567428000 110.511, 1.82476 2012-07-26T17:00:54.000-04:00

567428000 110.51, 1.8243 2012-07-26T18:52:14.000-04:00

533632000 110.529, 1.80925 2012-07-26T21:50:58.000-04:00

567428000 110.51, 1.82616 2012-07-26T21:51:34.000-04:00

533404000 110.607, 1.8186 2012-07-26T21:51:44.000-04:00

565466000 110.541, 1.68275 2012-07-27T18:47:11.000-04:00

567428000 110.507, 1.64728 2012-07-27T20:37:45.000-04:00

574984000 110.394, 1.55067 2012-07-28T00:06:44.000-04:00

533018900 110.536, 1.72654 2012-07-28T09:27:16.000-04:00

533000903 110.515, 1.79155 2012-07-28T10:46:19.000-04:00

567428000 110.394, 1.54579 2012-07-28T20:21:04.000-04:00

563126000 110.456, 1.62162 2012-07-28T22:36:39.000-04:00

563126000 110.455, 1.619 2012-07-28T22:38:52.000-04:00

533018900 110.463, 1.62641 2012-07-28T22:34:12.000-04:00

305146000 110.453, 1.61458 2012-07-29T11:58:29.000-04:00

574000400 110.535, 1.72491 2012-07-29T16:32:26.000-04:00

533413000 110.448, 1.58356 2012-07-29T20:10:53.000-04:00

533413000 110.446, 1.583 2012-07-29T21:41:56.000-04:00

533000855 110.459, 1.6229 2012-07-29T21:41:55.000-04:00

533413000 110.446, 1.58323 2012-07-29T21:55:10.000-04:00

305146000 110.453, 1.61455 2012-07-29T22:19:20.000-04:00

533413000 110.446, 1.58297 2012-07-29T23:51:49.000-04:00

533413000 110.396, 1.55318 2012-07-30T09:04:05.000-04:00

533413000 110.396, 1.55317 2012-07-30T10:02:15.000-04:00

533170036 110.515, 1.65182 2012-07-30T10:02:05.000-04:00

533413000 110.396, 1.55317 2012-07-30T10:53:44.000-04:00

533413000 110.396, 1.55317 2012-07-30T11:34:24.000-04:00

567428000 110.394, 1.54608 2012-07-30T14:27:43.000-04:00

533413000 110.396, 1.55315 2012-07-30T16:19:14.000-04:00

533413000 110.396, 1.55316 2012-07-30T18:09:03.000-04:00

533000707 110.621, 1.75047 2012-07-30T20:02:06.000-04:00

533413000 110.396, 1.55316 2012-07-30T21:54:05.000-04:00

538090123 110.452, 1.61433 2012-07-30T21:53:50.000-04:00

533000707 110.452, 1.58527 2012-07-30T21:54:57.000-04:00

533413000 110.396, 1.55319 2012-07-30T22:27:02.000-04:00

533413000 110.396, 1.55318 2012-07-30T22:27:24.000-04:00

533000707 110.375, 1.56852 2012-07-30T23:29:37.000-04:00

351177000 110.549, 1.70713 2012-07-30T23:30:28.000-04:00

533413000 110.396, 1.5532 2012-07-31T08:47:33.000-04:00

533413000 110.396, 1.55316 2012-07-31T10:35:37.000-04:00

533413000 110.396, 1.55315 2012-07-31T11:12:37.000-04:00

533413000 110.396, 1.55314 2012-07-31T14:08:37.000-04:00

1503 110.532, 1.79345 2012-07-31T14:12:13.000-04:00

533413000 110.396, 1.55317 2012-07-31T17:58:33.000-04:00

533413000 110.487, 1.63994 2012-07-31T19:36:01.000-04:00

567428000 110.394, 1.54604 2012-07-31T19:43:34.000-04:00

533016600 110.556, 1.79655 2012-08-01T12:25:16.000-04:00

564791000 110.536, 1.74569 2012-08-01T19:26:01.000-04:00





_______________________________________________
geomesa-users mailing list
geomesa-users@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
http://www.locationtech.org/mailman/listinfo/geomesa-users

 




_______________________________________________
geomesa-users mailing list
geomesa-users@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
http://www.locationtech.org/mailman/listinfo/geomesa-users

 



_______________________________________________
geomesa-users mailing list
geomesa-users@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
http://www.locationtech.org/mailman/listinfo/geomesa-users

Back to the top