Ad

kyuubi: Serverless SQL on Data Warehouses

Kyuubi provides a distributed gateway for serverless SQL queries on data warehouses and lakehouses, enabling easy SQL access to large datasets with multi-tenancy and scalability.
Screenshot of apache/kyuubi homepage

Kyuubi provides a pure SQL gateway with Thrift JDBC/ODBC, allowing users to query large datasets using Spark SQL engines. It addresses the limitations of HiveServer2 and Spark Thrift Server (STS) by offering a loosely coupled architecture for improved resource isolation, security, and concurrency. Kyuubi's multi-tenant design enables administrators to effectively manage computing resources and ensure data security for different users. Kyuubi is built using Scala and leverages Spark SQL engines for query execution.

Kyuubi supports a HiveServer2-like API, facilitating migration of existing workloads to Spark SQL. It offers multi-tenant Spark support, promoting resource isolation and security. Kyuubi's architecture enables running Spark in a serverless way, removing client-side Spark setup complexities. It supports various cluster managers like YARN and Kubernetes for flexible deployment.

  • Multi-tenancy: Enables resource isolation and security for multiple users.
  • Serverless SQL: Simplifies SQL query execution without Spark cluster management.
  • Heterogeneous Support: Compatible with various cluster managers (YARN, Kubernetes).
  • DataLake Integration: Provides access to data lakes and supports catalog management and authorization.
  • High Concurrency: Loosely coupled architecture enhances client concurrency and stability for scalable workloads.

Kyuubi is an active project with continuous development and maintenance, indicated by regular commits and community engagement. It has a solid release history and a supportive community. Recent commits and issues show ongoing development efforts, and a comprehensive documentation set is available. The presence of active contributors further validates its maturity.

Kyuubi benefits data analysts and data scientists by providing a simpler and more scalable interface to large datasets. It facilitates workloads like porting HiveServer2 applications to Spark SQL and enables data lake analytics with a single SQL interface. Kyuubi offers improved performance, resource management, and security compared to traditional solutions by supporting various cluster managers, a valuable asset for organizations managing big data.

Summarize:
Share:
Stars
2,371
Forks
1,031
Issues
543
Created
8 years ago
Commit
18 hours ago
License
APACHE-2.0
Archived
No
Updated 8 hours ago

Similar Repositories