| 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 
 |