Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[geomesa-users] Error when querying date/time range

Using the geomesa-quickstart-hbase (1.3.3.1-SNAPSHOT), I am receiving query results outside of the temporal (when) query parameters when I only specify the 'when' attribute.

If I construct the following filter, it works as expected:

String cql = cqlGeometry + " AND " + cqlDates  + " AND " + cqlAttributes; // line 172

queryFeatures(simpleFeatureTypeName, dataStore,
        "Where", -78.5, 37.5, -78.0, 38.0,
        "When", "2014-09-01T06:00:00.000Z", "2014-09-01T07:00:00.000Z",
        "(Who = 'Bierce')");

CONSOLE OUTPUT:
1.   Bierce|233179|Tue Jul 29 01:29:23 UTC 2014|POINT (-78.1563914300412 37.55068370938787)|null


However, if I construct a filter with only the temporal ('when') parameter, I receive results outside of the specified temporal range:

String cql = cqlDates; // Changing line 172 to this - only specifying the date range

queryFeatures(simpleFeatureTypeName, dataStore,
        "Where", -78.5, 37.5, -78.0, 38.0,
        "When", "2014-09-01T06:00:00.000Z", "2014-09-01T07:00:00.000Z",
        "(Who = 'Bierce')");

CONSOLE OUTPUT:
1.  Clemens|376958|Tue Jul 29 01:24:52 UTC 2014|POINT (-79.32356935554027 37.2330933099611)|null
2.  Bierce|242290|Tue Jul 29 01:04:21 UTC 2014|POINT (-79.26106474788082 37.35070155601285)|null
3.  Bierce|26866|Tue Jul 29 01:06:28 UTC 2014|POINT (-79.24711788069924 37.6932623925761)|null
4.  Bierce|953185|Tue Jul 29 01:34:06 UTC 2014|POINT (-79.04971454350397 37.358282818762085)|null
5.  Addams|269454|Tue Jul 29 01:53:22 UTC 2014|POINT (-78.77024220619475 37.70942117347827)|null
6.  Clemens|303761|Tue Jul 29 02:01:06 UTC 2014|POINT (-78.81748849058852 37.7419228550425)|null
7.  Clemens|768161|Tue Jul 29 02:20:33 UTC 2014|POINT (-79.2399050863839 37.06486923666385)|null
8.  Clemens|961637|Tue Jul 29 03:19:43 UTC 2014|POINT (-79.15194165432969 37.25217823548506)|null
9.  Addams|797358|Tue Jul 29 03:15:58 UTC 2014|POINT (-78.92912065781368 37.150616043436834)|null
10.  Addams|701901|Tue Jul 29 03:16:15 UTC 2014|POINT (-79.00045739977287 37.210848811939385)|null

The above output is clearly outside the specified date range (01 Sep 2014 0600hrs - 01 Sep 2014 0700hrs) but I am not sure why only specifying the temporal (when) component would be causing this. 

Any assistance would be greatly appreciated. Thank you!

-Joel

Back to the top