2 ms·
Spark [1], Presto [2], and Drill [3] can all do that with connectors to different data sources and varying support for advanced SQL. Pulsar has support for Pre
by manigandham 7y ago
Spark [1], Presto [2], and Drill [3] can all do that with connectors to different data sources and varying support for advanced SQL.
Pulsar has support for Presto: https://pulsar.apache.org/docs/en/sql-overview/ https://pulsar.apache.org/docs/en/sql-overview/
Pulsar isn't a KV store though, it's a distributed log/messaging system that supports a "key" for each message that can be used when scanning or compacting a stream. GET and SET aren't individual operations but rather scans through a stream or publishing a new message.
If you just want to have a SQL interface to KV stores or messaging systems that support a message key then Apache Calcite [4] can be used as a query parser and planner. There are examples of it being used for Kafka [5].
1. https://spark.apache.org/ https://spark.apache.org/
2. https://prestodb.io/ https://prestodb.io/
3. https://drill.apache.org/ https://drill.apache.org/
4. https://calcite.apache.org/ https://calcite.apache.org/
5. https://github.com/rayokota/kareldb https://github.com/rayokota/kareldb