I note there are some old Jira issues about Cassandra storage, and have this concept as to why it could be very valuable for Drill. Can anyone support or refute the idea?
Cassandra is an excellent engine for high volume ingest, but support for aggregations and scans is very limited. Would a Drill plugin support the ability to query a Cassandra keyspace using the partition keys, then perform aggregations within Drill, adding an "analytics layer" in Drill onto Cassandra? This seems like a very useful approach, but I don't know the level of effort in getting Calcite to properly determine which part of the SQL query passed to Drill can be segmented to CQL to push down to Cassandra, and then aggregate to summarize the results. Is there any active effort in this area?