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
Teradata VantageCloud
Teradata VantageCloud: The complete cloud analytics and data platform for AI.
Teradata VantageCloud is an enterprise-grade, cloud-native data and analytics platform that unifies data management, advanced analytics, and AI/ML capabilities in a single environment. Designed for scalability and flexibility, VantageCloud supports multi-cloud and hybrid deployments, enabling organizations to manage structured and semi-structured data across AWS, Azure, Google Cloud, and on-premises systems. It offers full ANSI SQL support, integrates with open-source tools like Python and R, and provides built-in governance for secure, trusted AI. VantageCloud empowers users to run complex queries, build data pipelines, and operationalize machine learning models—all while maintaining interoperability with modern data ecosystems.
Learn more about Teradata VantageCloud
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
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
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
Integrations
Company Information
Apache Software Foundation
Founded: 1999
United States
kylin.apache.org
Videos and Screen Captures
Other Useful Business Software
Build Agents and Models on One Platform
Gemini Enterprise Agent Platform is Google Cloud's comprehensive platform for developers to build, scale, govern, and optimize agents and models. Choose from Google's most advanced models and third-party models like Anthropic's Claude Model Family.
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.
