Hi All, Good morning!
We are implementing an OLAP engine on Hadoop. We store the aggregations as documents in elastic search. Elastic search provides a JSON based query DSL that can be used via REST API to filter and select these aggregations. We want to provide an SQL interface on top of this...and power the queries through the cubes that we store in Elastic Search. I am seeking your guidance on how to go about it using calcite and avatica. We already developed a model.json for ES and able to run SQL on Elastic search from sqlline that accompanies calcite. But what we would like to do is deploy a JDBC server and automatically serve queries either from elastic search or through hiveserver. We are not clear how to roll out our own jdbc client and server... Can some1 explain this please? Also in the calcite presentation, I found references to lattice and tiles. I am yet to find out what are their roles are within calcite and how our project could benefit out from these. If one of you could throw some light, I would be grateful. Thanks, Best, Sarnath Best, Sarnath
