Jethro's SQL acceleration layer has demonstrated faster query performance than both Impala and Redshift on live independent TPC-DS benchmarks. Benchmarks were measured on Tableau and Qlik BI tools.
SQL-on-Hadoop Benchmarks
| Hardware | Data Format | Hadoop Cluster | Compute Cluster | Total RAM, CPU | AWS $ per hr. |
|---|---|---|---|---|---|
| Jethro | Jethro indexes | 3x m1.xlarge | 2x r3.4xlarge (spot) | 290GB, 44 cores | $0.75 |
| Impala | Parquet | 7x r3.2xlarge | 450GB, 60 cores | $5.00 | |
| 1x r3.xlarge | |||||
| Redshift | Redshift | 6x dc1.large | 90GB, 12 cores | $1.50 |
Live SQL-on-Hadoop TPC-DS Benchmarks Impala and Jethro on Tableau
Follow the steps below to access live TPC-DS benchmarks for Jethro, Impala and Redshift
- Navigate to: tableau.jethrodata.com
- Login: demo | demo
- Choose workbook: Jethro, Impala, Redshift
- Dashboard interaction: choose year, category or any other filter to drill-down
- Data
- Based on TPC-DS benchmark
- 1TB raw data (400GB fact)
- Fact table: ~2.9B rows; Dimensions: 7
Live SQL-on-Hadoop TPC-DS Benchmarks Impala and Jethro on Qlik
- Navigate to: http://jethrodata.qlik.com
- Choose workbook: Jethro, Impala, Redshift
- Dashboard interaction: choose other filter to drill-down
- Data
- Based on TPC-DS benchmark
- 600GB raw data
- Singe table: ~2.5B rows
