Apache Impala
impala.apache.org
- Free plan
- macOS
- Linux
- API
- Self-hosted
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.
Plans
Every plan and priceApache Impala open-source software
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.