Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [geomesa-users] Is setting locality groups and group by queries possible in geomesa
Hi,

I have GPS data in postgres (relational). It has 26 tables which needs to be de-normalized before storing them in to Geomesa as it can not provide relational queries. we have to join/combine two or more tables to create one. This increases the number of columns in a table. Some attributes are mostly queried together. As we want to group attributes queried together we need to apply locality groups over column families.   For which I at-least need to know the names of column families of my attributes.

Thanks
Vaibhav

On 03/30/2016 06:54 PM, Emilio Lahr-Vivaz wrote:
Hi Vaibhav,

GeoMesa will create certain locality groups based on your data, but we don't provide any hooks to modify them, and in general I wouldn't suggest it. Of course, 
you can always set up locality groups  through the Accumulo shell. Do you have a particular use case in mind?

GeoTools CQL doesn't support group-by, but you can use the GeoMesa Apache Spark integration to do so. You use an initial CQL filter (which could be Filter.INCLUDE)
to select your features, then you can manipulate them directly. See the examples here:


Although currently it's not well documented, GeoMesa also provides SparkSql integration which will let you mix SQL and CQL in your queries. See:


Thanks,

Emilio

On Wed, 2016-03-30 at 17:42 +0530, vaibhav.thapliyal wrote:
Hi everyone,

Is there a way to set up locality groups on geomesa database? And can we 
use group by clause in doing queries that are not geospatial?

Thanks
Vaibhav
_______________________________________________
geomesa-users mailing list
geomesa-users@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://www.locationtech.org/mailman/listinfo/geomesa-users



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

Back to the top