apache / kyuubi

Apache Kyuubi is a distributed and multi-tenant gateway to provide serverless SQL on data warehouses and lakehouses.
https://kyuubi.apache.org/
Apache License 2.0
2.1k stars 914 forks source link

Kyuubi Cassandra Integration enhancement #697

Open kmsantanu opened 3 years ago

kmsantanu commented 3 years ago

1. Describe the feature

ANSI SQL 92 standard queries can not run directly on Cassandra hence Kyuubi can run the queries and get the result.

2. Motivation

Recent years Cassandra is much popular as data storage and most BI tools need a Cassandra adaptor. Kyuubi can solve the problem.

3. Describe the solution

  1. packaging kyuubi Spark Cassandra open-source driver part of the library.

  2. provide the necessary configuration to Kubbi config file or hive JDBC url

  3. documentation for Kyuubi cassandra integration

4. Additional context

Small java or scala sample code to run a query to retrieve data from cassandra,

yaooqinn commented 3 years ago

thank you @kmsantanu. Are we going to add a friendly user guide to introduce how to integrate Kyuubi with Cassandra using https://github.com/datastax/spark-cassandra-connector?

Also cc @pan3793