Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Apache Kylin
Apache Kylin

23
30
+ 1
8
Apache Impala
Apache Impala

58
55
+ 1
8
Add tool

Apache Kylin vs Impala: What are the differences?

Apache Kylin: OLAP Engine for Big Data. Apache Kylin™ is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop/Spark supporting extremely large datasets, originally contributed from eBay Inc; Impala: Real-time Query for Hadoop. Impala is a modern, open source, MPP SQL query engine for Apache Hadoop. Impala is shipped by Cloudera, MapR, and Amazon. With Impala, you can query data, whether stored in HDFS or Apache HBase – including SELECT, JOIN, and aggregate functions – in real time.

Apache Kylin and Impala belong to "Big Data Tools" category of the tech stack.

Some of the features offered by Apache Kylin are:

  • Extremely Fast OLAP Engine at Scale
  • ANSI SQL Interface on Hadoop
  • Interactive Query Capability

On the other hand, Impala provides the following key features:

  • Do BI-style Queries on Hadoop
  • Unify Your Infrastructure
  • Implement Quickly

Apache Kylin and Impala are both open source tools. Apache Kylin with 2.23K GitHub stars and 992 forks on GitHub appears to be more popular than Impala with 2.18K GitHub stars and 824 GitHub forks.

What is Apache Kylin?

Apache Kylin™ is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop/Spark supporting extremely large datasets, originally contributed from eBay Inc.

What is Apache Impala?

Impala is a modern, open source, MPP SQL query engine for Apache Hadoop. Impala is shipped by Cloudera, MapR, and Amazon. With Impala, you can query data, whether stored in HDFS or Apache HBase – including SELECT, JOIN, and aggregate functions – in real time.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose Apache Kylin?
Why do developers choose Apache Impala?

Sign up to add, upvote and see more prosMake informed product decisions

    Be the first to leave a con
      Be the first to leave a con
      What companies use Apache Kylin?
      What companies use Apache Impala?

      Sign up to get full access to all the companiesMake informed product decisions

      What tools integrate with Apache Kylin?
      What tools integrate with Apache Impala?

      Sign up to get full access to all the tool integrationsMake informed product decisions

      What are some alternatives to Apache Kylin and Apache Impala?
      Apache Spark
      Spark is a fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark's standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.
      Presto
      Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.
      Druid
      Druid is a distributed, column-oriented, real-time analytics data store that is commonly used to power exploratory dashboards in multi-tenant environments. Druid excels as a data warehousing solution for fast aggregate queries on petabyte sized data sets. Druid supports a variety of flexible filters, exact calculations, approximate algorithms, and other useful calculations.
      Amazon Athena
      Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.
      Apache Flink
      Apache Flink is an open source system for fast and versatile data analytics in clusters. Flink supports batch and streaming analytics, in one system. Analytical programs can be written in concise and elegant APIs in Java and Scala.
      See all alternatives
      Decisions about Apache Kylin and Apache Impala
      No stack decisions found
      Interest over time
      Reviews of Apache Kylin and Apache Impala
      No reviews found
      How developers use Apache Kylin and Apache Impala
      No items found
      How much does Apache Kylin cost?
      How much does Apache Impala cost?
      Pricing unavailable
      Pricing unavailable
      News about Apache Kylin
      More news
      News about Apache Impala
      More news