| Prepare Hive- testbench |
1 |
Download latest Hive-testbench from Hortonworks Github repository. |
| 2 |
Run tpcds-build.shto build TPC-DS data generator. |
| 3 |
Run tpcds-setup to set up the testbench database and load the data into created tables. |
| Database on remote Hadoop cluster and load data |
1 |
Create LLAP database on remote IBM Storage® Scale HDFS Transparency cluster. |
| 2 |
Create 24 tables in LLAP database required to run the Hive test benchmark queries. |
| 3 |
Check the Hadoop file system location for the 24 table directories created on the remote IBM Storage Scale™ HDFS Transparency cluster. |
| TPC-DS benchmarking |
1 |
Switch from default database to LLAP database. |
| 2 |
Run query52.sqlscript. |
| 3 |
Run query55.sqlscript. |
| 4 |
Run query91.sqlscript. |
| 5 |
Run query42.sql script. |
| 6 |
Run query12.sqlscript. |
| 7 |
Run query73.sqlscript. |
| 8 |
Run query20.sqlscript. |
| 9 |
Run query3.sqlscript. |
| 10 |
Run query89.sqlscript. |
| 11 |
Run query48.sqlscript. |