Apache Impala vs Exasol

Apache Impala is a free, open-source native analytic database for SQL queries on open data and table formats. It targets low-latency, high-concurrency business intelligence and analytics in Hadoop environments and is described as scaling linearly, including for multitenant use. Impala works with HDFS, HBase and Amazon S3, plus Apache Kudu, Apache Iceberg and other listed sources. Supported formats include delimited text, Parquet, Avro, SequenceFile and RCFile, with Snappy, GZIP, Deflate and BZIP codecs. Clients can connect through impala-shell, Hue, JDBC or ODBC. The system reuses Hadoop file formats, metadata, security and resource-management frameworks, and shares metadata and an ODBC driver with Apache Hive. Kudu tables support queries and efficient updates or deletes; Iceberg tables can be registered with the Hive Metastore. Kerberos, Apache Ranger authorization, auditing and encrypted JDBC or ODBC connections are supported. Impala runs on Linux and macOS, supports API use and self-hosted deployment, and is licensed under Apache License 2.0.

Exasol is a database for analytics and high-concurrency AI workloads, available in cloud, on-premises, hybrid, and fully managed SaaS deployments. The company says teams can analyze billions of rows in seconds and that automatic self-indexing helps tune performance. SaaS includes five databases, multi-cluster support, basic UDF support, advanced in-database analytics, and data virtualization. Teams can scale vertically or add clusters with dedicated compute for work such as data ingest or machine learning. The 30-day SaaS trial includes $200 of usage and requires no credit card. Pay-as-you-go compute is billed hourly; XS is $3.30 a month and S is $6.60 a month, while storage is listed separately at $25 a month. Free options include Exasol Personal, licensed for a single user and up to two connected data sources, and Community Edition, limited to 200GB of data. Exasol lists integrations including Airbyte, Alation, Amazon QuickSight, Apache Airflow, and Apache Superset. Its documentation covers multiple authentication methods and TLS encryption for database connections; encryption at rest must be configured on the supplied file systems and devices.