Audience
Companies, enterprises and developers in search of an analytical data warehouse solution for Big Data
About Apache Kylin
Apache Kylin™ is an open source, distributed Analytical Data Warehouse for Big Data; it was designed to provide OLAP (Online Analytical Processing) capability in the big data era. By renovating the multi-dimensional cube and precalculation technology on Hadoop and Spark, Kylin is able to achieve near constant query speed regardless of the ever-growing data volume. Reducing query latency from minutes to sub-second, Kylin brings online analytics back to big data. Kylin can analyze 10+ billions of rows in less than a second. No more waiting on reports for critical decisions. Kylin connects data on Hadoop to BI tools like Tableau, PowerBI/Excel, MSTR, QlikSense, Hue and SuperSet, making the BI on Hadoop faster than ever. As an Analytical Data Warehouse, Kylin offers ANSI SQL on Hadoop/Spark and supports most ANSI SQL query functions. Kylin can support thousands of interactive queries at the same time, thanks to the low resource consumption of each query.
Other Popular Alternatives & Related Software
Amazon Redshift
Amazon Redshift is a cloud-based data warehouse solution from AWS designed to deliver high-performance analytics and support modern AI-driven workloads. The platform enables organizations to analyze large volumes of structured and unstructured data across data warehouses, data lakes, and third-party sources using SQL. Redshift is built for scalability and cost efficiency, offering improved throughput and price-performance with AWS Graviton-powered RG instances and Redshift Serverless options. The solution also supports near real-time analytics through zero-ETL integrations that connect operational databases, streaming services, and enterprise applications without complex data pipelines. Amazon Redshift integrates with Amazon SageMaker and Amazon Bedrock to support advanced machine learning, analytics, and generative AI use cases.
Learn more about Amazon Redshift
SSAS
Installed as an on-premises server instance, SQL Server Analysis Services supports tabular models at all compatibility levels (depending on version), multidimensional models, data mining, and Power Pivot for SharePoint. A typical implementation workflow includes installing a SQL Server Analysis Services instance, creating a tabular or multidimensional data model, deploying the model as a database to a server instance, processing the database to load it with data, and then assigning permissions to allow data access. When ready to go, the data model can be accessed by any client application supporting Analysis Services as a data source. Models are populated with data from external data systems, usually data warehouses hosted on a SQL Server or Oracle relational database engine (Tabular models support additional data source types).
Learn more about SSAS
StarTree
StarTree, powered by Apache Pinot™, is a fully managed real-time analytics platform built for customer-facing applications that demand instant insights on the freshest data. Unlike traditional data warehouses or OLTP databases—optimized for back-office reporting or transactions—StarTree is engineered for real-time OLAP at true scale, meaning:
- Data Volume: query performance sustained at petabyte scale
- Ingest Rates: millions of events per second, continuously indexed for freshness
- Concurrency: thousands to millions of simultaneous users served with sub-second latency
With StarTree, businesses deliver always-fresh insights at interactive speed, enabling applications that personalize, monitor, and act in real time.
Learn more about StarTree
Apache Pinot
Pinot is designed to answer OLAP queries with low latency on immutable data. Pluggable indexing technologies - Sorted Index, Bitmap Index, Inverted Index. Joins are currently not supported, but this problem can be overcome by using Trino or PrestoDB for querying. SQL like language that supports selection, aggregation, filtering, group by, order by, distinct queries on data. Consist of of both offline and real-time table. Use real-time table only to cover segments for which offline data may not be available yet. Detect the right anomalies by customizing anomaly detect flow and notification flow.
Learn more about Apache Pinot
Integrations
Company Information
Apache Software Foundation
Founded: 1999
United States
kylin.apache.org
Videos and Screen Captures
Other Useful Business Software
99.99% Uptime for MySQL and PostgreSQL Databases
Cloud SQL Enterprise Plus delivers near-zero downtime with 35 days of point-in-time recovery. Supports MySQL, PostgreSQL, and SQL Server.
Product Details
Platforms Supported
Cloud
Training
Documentation
In Person
Support
Online
Apache Kylin Frequently Asked Questions
Q: What kinds of users and organization types does Apache Kylin work with?
Apache Kylin works with these users and organization types: Mid Size Business, Small Business, Enterprise, Freelance, Nonprofit, Government, and Startup.
Q: What languages does Apache Kylin support in their product?
Apache Kylin supports these languages: English.
Q: What kind of support options does Apache Kylin offer?
Apache Kylin offers support via online.
Q: What other applications or services does Apache Kylin integrate with?
Apache Kylin integrates with: Apache Hive, Apache Kafka, Apache Spark, Apache Superset, Astro by Astronomer, Chat2DB, Microsoft Excel, Hadoop, Hue, Microsoft Power BI, Preset, Qlik Sense, RATH, and Tableau.
Q: What type of training does Apache Kylin provide?
Apache Kylin provides training in the form of documentation and in person.
