Using Trino’s TPCDS or TPCH connectors

Datasets of TPC-DS or TPC-H are available via tpcds or tpch catalogs.

zookage@client-node-0:~$ trino
trino> SHOW SCHEMAS FROM tpcds;
       Schema
--------------------
 information_schema
 sf1
 sf10
 sf100
 sf1000
 sf10000
 sf100000
 sf300
 sf3000
 sf30000
 tiny
(11 rows)

trino> SHOW TABLES FROM tpcds.tiny;
         Table
------------------------
 call_center
 catalog_page
 catalog_returns
 catalog_sales
 customer
 customer_address
 customer_demographics
 date_dim
 dbgen_version
 household_demographics
 income_band
 inventory
 item
 promotion
 reason
 ship_mode
 store
 store_returns
 store_sales
 time_dim
 warehouse
 web_page
 web_returns
 web_sales
 web_site
(25 rows)

You can copy the datasets as another format. This is an example to copy customer as a Hive table.

zookage@client-node-0:~$ trino
trino> CREATE TABLE hive.default.customer AS SELECT * FROM tpcds.tiny.customer;
CREATE TABLE: 1000 rows

You can query it from another query engine or system.

zookage@client-node-0:~$ beeline
Connecting to jdbc:hive2://hive-hiveserver2:10000/default;password=dummy;user=zookage
Connected to: Apache Hive (version 3.1.2)
...
----------------------------------------------------------------------------------------------
        VERTICES      MODE        STATUS  TOTAL  COMPLETED  RUNNING  PENDING  FAILED  KILLED
----------------------------------------------------------------------------------------------
Map 1 .......... container     SUCCEEDED      1          1        0        0       0       0
Reducer 2 ...... container     SUCCEEDED      1          1        0        0       0       0
----------------------------------------------------------------------------------------------
VERTICES: 02/02  [==========================>>] 100%  ELAPSED TIME: 5.28 s
----------------------------------------------------------------------------------------------
...
+---------------+------+
| c_salutation  | _c1  |
+---------------+------+
| NULL          | 30   |
| Dr.           | 283  |
| Miss          | 137  |
| Mr.           | 160  |
| Mrs.          | 98   |
| Ms.           | 125  |
| Sir           | 167  |
+---------------+------+
7 rows selected (10.497 seconds)