Trino Clickzetta Connector User Guide

Introduction to Trino

Trino is a high-performance, open-source, distributed SQL query engine that supports querying across various data sources, including but not limited to Hive, MySQL, PostgreSQL, MongoDB, Redis, Cassandra, Kafka, etc. Trino is commonly used for offline query acceleration and federated queries across multiple data sources, providing users with a convenient data processing and analysis experience.

This document will introduce how to use the Trino-Clickzetta plugin to directly access and analyze data in the ClickZetta LakeHouse through Trino.

Preparations

Please ensure that Trino is installed. You can choose to download the Trino 402 version server.
Download the Trino-Clickzetta plugin by visiting the plugin download page, and extract the plugin to the plugin folder in the Trino installation directory.

Download the Trino Clickzetta plugin configuration file by visiting the configuration file download page, and copy the configuration file to the etc/catalog folder in the Trino installation directory. Modify the following three items in the configuration file according to your actual situation:


iceberg.cz.uri=jdbc:clickzetta://instance.api.singdata.com/workspace?schema=public&vcluster=default
iceberg.cz.user=username
iceberg.cz.password=password

Start or restart the Trino service. Execute the following command in the Trino installation directory:
```
bin/launcher start/restart
```

Using Trino Clickzetta Plugin

Use the Trino client to connect to the Trino server. You can download the Trino client and refer to the Client Usage Guide for instructions.


java -jar trino-cli-402-executable.jar --server localhost:8080 --catalog cziceberg --schema public

2. View tables in ClickZetta LakeHouse from Trino client

In the Trino client, execute the following command to view the tables in ClickZetta LakeHouse:
```
show tables;
```

You will see a table list similar to the following:


        Table
----------------------------
lh_smoke_test_bulkload
lh_smoke_test_igs
spark_src
spark_src_complex_type
spark_srcpart
spark_srcpart_complex_type
spark_srcpart_date
spark_srcpart_int
(8 rows)


### 3. Query data in the table. For example, query the total number of records in the `lh_smoke_test_igs` table:


select count(*) from lh_smoke_test_igs;

The result is similar to:


_col0
-------
100

Precautions

This plugin is developed and verified only for Trino version 402.
Currently, the plugin only supports reading data from ClickZetta LakeHouse, and does not support writing data.
The plugin does not currently support reading tables that have been updated or deleted in ClickZetta LakeHouse.
For detailed information on Trino configuration files, please refer to the Trino official documentation.