Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Apache Impala

impala.apache.org

  • Free plan
  • macOS
  • Linux
  • API
  • Self-hosted
7.1 Club score Visit impala.apache.org

What Apache Impala is

Apache Impala is a free, open-source analytic database for SQL queries on open data and table formats. It is designed for low-latency, high-concurrency business intelligence and analytics in the Hadoop ecosystem, and scales linearly, including in multitenant environments. Impala can query data in HDFS, HBase, and Amazon S3, using formats such as delimited text, Parquet, Avro, SequenceFile, and RCFile with Snappy, GZIP, Deflate, or BZIP compression. Clients connect through impala-shell, Hue, JDBC, or ODBC. The database reuses file formats, metadata, security, and resource-management frameworks from Hadoop deployments and shares metadata and an ODBC driver with Apache Hive. It can query Kudu tables and perform updates or deletes, and interact with Iceberg tables registered in the Hive Metastore. Security options include Kerberos, Apache Ranger fine-grained authorization, auditing, and encrypted JDBC or ODBC connections. Impala is available for Linux, macOS, API use, and self-hosted deployment. The project cautions that it does not replace MapReduce-based batch frameworks such as Hive for long-running ETL and batch jobs.

Who it suits

It suits teams running SQL analytics or BI queries on data in the Hadoop ecosystem, including data stored in HDFS, HBase, or Amazon S3. Teams with long-running ETL or batch work should retain a MapReduce-based framework for those jobs.

Good to know, and what to watch

  • Supports SQL queries across several Hadoop data sources.
  • Offers low-latency, high-concurrency analytics.
  • Connects through shell, Hue, JDBC, or ODBC.
  • Integrates with Kudu and Iceberg tables.
  • Free under the Apache License 2.0.
  • Does not replace frameworks for long-running ETL and batch jobs.
  • Requires self-hosted deployment.

Apache Impala open-source software

Free

Free plan

The verdict

Impala is aimed at interactive analytics on open data formats, with Hadoop integration and multiple client interfaces. It is not a substitute for a batch framework when long-running ETL is the task.

What the maker publishes

Batch-processing limitation
Impala does not replace MapReduce-based batch frameworks such as Hive, which are suited to long-running ETL and batch jobs. source
Client interfaces
Clients can connect through impala-shell, Hue, JDBC, or ODBC. source
Data formats
Supported formats include delimited text, Parquet, Avro, SequenceFile, and RCFile, with Snappy, GZIP, Deflate, and BZIP compression codecs. source
Downloads
The downloads page lists releases with SHA512 checksums and GPG signatures, and says DEB/RPM packages are available from GitHub Releases. source
Encrypted connections
JDBC and ODBC applications can use Kerberos authentication, TLS/SSL encryption, or both. source
Iceberg integration
Impala can add existing Iceberg tables to the Hive Metastore with CREATE EXTERNAL TABLE and interact with them. source
Infrastructure reuse
Impala uses the same file and data formats, metadata, security, and resource-management frameworks as Hadoop deployments. source
Kudu integration
Impala can query Kudu tables and perform efficient update or delete operations when data changes continuously or in small batches. source
Product type
Apache Impala is an open-source native analytic database for open data and table formats. source
Query performance
Impala provides low-latency and high-concurrency BI and analytic queries on the Hadoop ecosystem. source
Scaling
Impala scales linearly, including in multitenant environments. source
Security
Impala integrates Kerberos authentication with Apache Ranger fine-grained authorization and provides auditing capabilities. source
SQL compatibility
Impala supports SQL and uses the same metadata and ODBC driver as Apache Hive. source
Storage systems
Impala supports data in HDFS, HBase, and Amazon S3. source
Support channels
The project provides user and developer mailing lists, Jira issues, Slack, Stack Overflow, and Quora community channels. source

Checked against the maker's pages on 1 Oct 2026.