Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [geomesa-users] Date Indexing, Stucked queries

Hi Marcel,

Could you provide your full simple feature type string? I'll try to reproduce the error you're seeing with the full table scan. Also, what version of geomesa are you currently using? Did you re-ingest your data using the new version? If not, what was the old version that you ingested the data with?

With regards to the queries not finishing - we try to optimize queries so that they only scan records that are likely to match. However, depending on the query, we can't always do that. If you're seeing the 'full table scan' warning, then the query won't completely return until it has scanned your entire dataset, even if none of the features actually match. In all cases, the scan should eventually return, but if you're getting memory errors you might need to bump up some settings somewhere. If java gets low on memory and starts swapping to disk, it can slow things to a crawl. Where are you seeing the heapspace errors?

Thanks,

Emilio

On 09/01/2015 11:58 AM, Marcel wrote:
Hello,
after some weeks of abstinence I continued working with Geomesa. First of all I updated to the new geomesa version and some of my problems got solved. Unfortunately others were not. My data imported successfully on the cluster, but it seems that my Date attribute was not indexed. I used "SQLDATE:Date:index=full" for this attribute. But when executing a query using a temporal filter the logger says: "Running full table scan for schema event with filter SQLDATE AFTER 1991-04-28T22:00:00+00:00". Is this the correct way to define that my attribute should be indexed?

Another problem seems to appear when there are 0 results for my query. These queries often dont finish. Sometimes even a HeapSpace error occurs. Maybe this stays in connection with my missing indexing date attribute when scanning over all records.

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



Back to the top