[geomesa-users] problem querying indexed data out with multi IN or = cql

[Diane Griffith <diane.griffith@xxxxxxxxxxxxxxx>]

We are on GeoMesa 1.2.0 on top of accumulo 1.6 with GeoServer 2.8.1.  We started experiencing issues combining complex cql quleries through GeoServer for sure once we started applying more attribute indexes on our data.

 

What seems to break down was when we did multiple IN or = cql queries through one geoserver call to the geomesa stack.  Generic examples of what I’m talking about that could fail would be against a column defined as a String (I’ll call it Keyword) with index=full with the cql looking something like the following 2 examples:

 

1.       (Keyword IN (‘test, ‘foo’)) 

2.       ((Keyword = ‘test’) OR (Keyword = ‘foo’))

 

If each was queried separately through geoserver for the certain bounding box it works.  But as soon as we combine each working IN/equal match together with the same bounding box it returns no matches via the GeoServer GetMap call.

 

Also on the same dataset a query that could succeed was something like:

 

((Keyword LIKE ‘foo%’) OR (Keyword IN (‘test’))

 

I knew I did combine other queries so I backed it off to a simple test dataset where I had not indexed any additional attribute columns.  So when I did similar string tests like the 2 that failed above, they worked against a non-indexed string attribute column.  I had no issues combining cql on admittedly non-indexed Double columns.  Unclear if I indexed them if I would experience similar combined CQL issues.

 

Is there a known issue doing a combined/multiple IN matches or = matches on an indexed string attribute column? 

 

Is there further things that anyone can suggest I look at to determine why a multi IN clause or = clause fails on an indexed string attribute column? 

 

Thanks,

Diane Griffith