Apache Kyuubi is a distributed, multi-tenant gateway that provides SQL query services for data lake query engines such as Spark, Flink, and Trino.
Features
-
Multi-tenancy: Kyuubi provides end-to-end multi-tenancy support for resource acquisition, data access, and metadata access by using a unified authentication and authorization layer.
-
High availability: Kyuubi uses ZooKeeper for load balancing, delivering enterprise-grade high availability and unlimited client concurrency.
-
Multiple workloads: Kyuubi handles multiple workloads on a single platform with a single data replica and a unified SQL interface.
Scenarios
-
Interactive analysis: Kyuubi enables enterprise-grade analytics platforms for interactive visual analytics on big data. It supports common computing frameworks along with Java Database Connectivity (JDBC) and Open Database Connectivity (ODBC) interfaces, allowing efficient querying through SQL or business intelligence (BI) tools. Kyuubi caches back-end engine instances at the user level to improve resource sharing and accelerate responses. It processes queries on large datasets in parallel and returns results quickly.
-
Batch data processing: Kyuubi provides a SQL interface for common batch processing such as large extract, transform, and load (ETL) processes. Kyuubi and its engines are storage-independent and support numerous data sources. Kyuubi can also isolate back-end engine instances at the connection level for better resource isolation and stability.
Comparison of Kyuubi, Livy, and Spark ThriftServer
|
Comparison item |
Kyuubi |
Livy |
Spark ThriftServer |
|
Supported interfaces |
SQL, Scala |
SQL, Scala, Python, and R |
SQL |
|
Supported engines |
Spark, Flink, Trino |
Spark |
Spark |
|
Spark version |
Spark 3.x |
Spark 2.x and Spark 3.x |
Included with the Spark component |
|
Protocol support |
Thrift and JDBC |
HTTP, Thrift, and JDBC |
Thrift and JDBC |
|
Client |
Kyuubi Beeline |
HTTP Client |
Spark Beeline |
|
High availability |
Support |
Support |
Not supported |
|
Resource isolation |
Support |
Support |
Not supported |
|
LDAP authentication |
Support |
Support |
Support |
|
Alibaba Cloud EMR version |
|
|
All versions |