Re: [geowave-dev] No results with cqlfilter

[Derek Yeager <dcy2003@xxxxxxxxx>]

Hi Marcel,

I would like to help you debug this issue.  Is the property "EventBaseCode" of type String or Integer?  You may find it easier to define your filter using the static CQL.toFilter() method.  For example:

• CQL.toFilter("EventBaseCode = 18")  --> if EventBaseCode is an Integer
  
• CQL.toFilter("EventBaseCode = '018'") --> if EventBaseCode is a String
  

The two query methods you are using are defined in different data store implementations (VectorDataStore vs. AccumuloDataStore) and follow different query paths under the covers in GeoWave.  I want to replicate the issue you are seeing so that I can properly debug it, but in order to do so I prefer to make as few assumptions as possible.  Would you mind sharing more code, the entire class if possible?

Thanks,
Derek

On Wed, Oct 28, 2015 at 1:11 PM, Marcel Jacob <m.jacob@xxxxxxxxxxx> wrote:

Hello,
I wrote a query which works fine with the following method:
datastore.query(INDEX, query, queryOptions);
When adding some cql-constraints the query also runs successfully using
the following method:
datastore.query(adapter, INDEX, query, eventFilter, Integer.MAX_VALUE);
But my result file is empty! I know that there have to be at least 3
results.
Version: 0.89-Snapshot.

Here is a code snippet for defining a filter and the adapter:

FilterFactory2 ff = CommonFactoryFinder.getFilterFactory2();
         Filter eventFilter = ff.equal(
                 ff.property("EventBaseCode"),
                 ff.literal("018"),
                 false);

FeatureDataAdapter adapter = (FeatureDataAdapter)
adapterStore.getAdapter(new ByteArrayId(
                 "geowave-gdelt"));

The property "EventBaseCode" and my adapter "geowave-gdelt" exists.
What could be the problem?
Is there another method for executing a query using a cqlfilter?

Best regards,
Marcel Jacob.
_______________________________________________
geowave-dev mailing list
geowave-dev@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://www.locationtech.org/mailman/listinfo/geowave-dev