Re: [geomesa-users] "Edit SQL View"

[Emilio Lahr-Vivaz <elahrvivaz@xxxxxxxx>]

Ah, sorry, I missed that you were using HBase - Spark and SQL support are currently limited to Accumulo, not HBase.

If you want to give a try to extending it for HBase, or adding coprocessors, we'd be happy to provide support.

Thanks,

Emilio

On 06/14/2016 12:42 PM, Alberto Ramón wrote:

In true, I have  a mess on my head   :)

-  I will try "Geomesa Compute", but I don't know if work with HBase or have any integration with GeoServer as client

-  I will try "Geomesa Web Data": I saw dependency list  ....I am afraid   :D

The requirement of spark cluster for this calculation, can be a overhead in final cost and complexity system

Other solution can be use, HBase coprocesor to filter and aggregate  ¿?

2016-06-14 18:24 GMT+02:00 Jim Hughes <jnh5y@xxxxxxxx>:

It is probably worth the disclaimer that GeoMesa's Spark support is limited to Accumulo.

Cheers,

Jim

On 06/14/2016 11:40 AM, Emilio Lahr-Vivaz wrote:

Hi Alberto,

I'm not sure if this would fit your use case, but we do expose spark-sql queries against GeoMesa accumulo through a REST API in geoserver. See the readme here:

https://github.com/locationtech/geomesa/tree/master/geomesa-web/geomesa-web-data

Like Jim said, the setup can be a bit difficult, so shout if you have any problems!

Thanks,

Emilio

On 06/14/2016 10:17 AM, Alberto Ramón wrote:

The idea is similar to (Using GeoMesa and HBase):

  Position | Attribute | Count

     P1     |       A      |   2
     P1     |       B      |   1
     P2     |       A      |   3
     P2     |       A      |   1

From GeoServer:

  User1: Select sum (count) ...                                             (Without filters)

  User2: Select sum (count) From .. Where Attribute = A  

Note: Using Postgis, we can do it with SQL View, but its not available on Geomesa & HBase

The user, can use Spark from GeoServer, to custom aggregates?
  (The user uses WMS to connet to GeoServer)

BR

 

2016-06-14 16:03 GMT+02:00 Jim Hughes <jnh5y@xxxxxxxx>:

Hi Ramon,

Great question.  Are you interested in something like SQL views to compute stats (maybe something like 'select count(*), id where cond1' over a region or to drive parameterized views described here: http://docs.geoserver.org/stable/en/user/data/database/sqlview.html?

Either would require some new development.  One possible solution would be to use GeoMesa's SparkSQL support to run a SQL query.  There's a fair bit of infrastructure required for that.  Alternatively, a limited SQL dialect could be supported and translated to GeoTools queries by a layer in the API. 

Thoughts?

Cheers,

Jim

On 06/14/2016 09:45 AM, Alberto Ramón wrote:

Hello

Q:In GeoServer + PostGIS, we see a "Edit SQL View" in Layer Option, this is very useful for calculate filtered aggregates "on demand" from OpenLayers

  But this option isn't in HBase + Geomesa?
 
  SOL1: Insert Pre-agregate data into Mesa
  PB1: We can't apply filters, and insert all combinations of pre-agregate its not possible
 
  SOL2: With: "...spark/analytics/CountByDay.scala" (/geomesa-users/msg00767.html)
  PB2: We need add cluster scala and move all raw data from geomesa spark (or use ECQL): The aggregation is not in Database engine (Like PostGIS)
 
  SOL3: ¿Other?

B.R.

 

_______________________________________________
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

_______________________________________________
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

_______________________________________________
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