Apache Impala vs Azure Synapse Analytics
Apache Impala
impala.apache.org
Azure Synapse Analytics
azure.microsoft.comSide by side
| Figure | Apache Impala | Azure Synapse Analytics |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | — |
| Open source | — | — |
| Web | — | Yes |
| macOS | Yes | — |
| Linux | Yes | — |
| API | Yes | — |
| Self-hosted | Yes | — |
| Plans published | 1 | 7 |
| Spec score · Query Engine Software | 8.2 (#8) | 6.2 (#21) |
| Spec score · OLAP Databases | 8.2 (#9) | 6.1 (#26) |
| Spec score · OLAP Software | 8.2 (#10) | 6.2 (#28) |
| Spec score · Analytics Databases | 8.2 (#10) | 6.2 (#26) |
| Spec score · Big Data Analytics Software | 8.1 (#11) | 6.0 (#28) |
Plans
Azure Synapse Analytics
- Serverless SQL poolPriced on request
- Dedicated SQL pool — pay as you goPriced on request
- Dedicated SQL pool — 1-year reservedPriced on request
- Dedicated SQL pool — 3-year reservedPriced on request
- Apache Spark — Memory OptimizedPriced on request
- Apache Spark — GPU acceleratedPriced on request
- Data Explorer computePriced on request
In their own words
Apache Impala
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.
Azure Synapse Analytics
Azure Synapse Analytics has no write-up on Specifiction yet; its figures are above.