TEquals and similar predicates cannot be pushed down

TEquals and similar predicates cannot be pushed down

TEquals, TContains, TOverlaps, etc. do not have representations from FilterToECQL*. As such, GeoMesa cannot serialize them for predicate pushdown.

In situations where they can be eliminated by the query planner, queries will work. Otherwise, they'll fail with an exception like: "TheTContains has not an ECQL expression".

I see a few options for addressing this issue.

Option 1: Add handling in the query planner to replace these predicates with predicates which can be pushed down.

Option 2: Update or wrap FilterToECQL so that these predicates are handled.

• https://github.com/geotools/geotools/blob/main/modules/library/cql/src/main/java/org/geotools/filter/text/ecql/FilterToECQL.java#L446-L485

Original JIRA Issue: https://geomesa.atlassian.net/browse/GEOMESA-3046

Key: GEOMESA-3046
Type: Story
Priority: Major
Status: To Do
Resolution: Unresolved
Reporter: James Hughes
Created: Mon, 5 Apr 2021 12:44:35 -0400
Updated: Mon, 5 Apr 2021 12:44:35 -0400
Affects Version(s): 2.0.2, 1.3.7, 2.1.4, 2.2.3, 2.3.3, 3.0.1, 2.4.2, 3.2.0, 3.1.1

Start by inspecting the GeoTools FilterToECQL.java handling around lines 446-485 and GeoMesa's FilterToECQL* integration. Determine how TEquals, TContains, and TOverlaps should be represented for predicate pushdown, then verify that affected queries serialize without the reported exception.