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