# Trino command line interface The Trino CLI provides a terminal-based, interactive shell for running queries. We can use it to connect Kyuubi server now. ## Start Kyuubi Trino Server First we should configure the trino protocol and the service port in the `kyuubi.conf` ``` kyuubi.frontend.protocols TRINO kyuubi.frontend.trino.bind.port 10999 #default port ``` ## Install Download [trino-cli-363-executable.jar](https://repo1.maven.org/maven2/io/trino/trino-jdbc/363/trino-jdbc-363.jar), rename it to `trino`, make it executable with `chmod +x`, and run it to show the version of the CLI: ``` wget https://repo1.maven.org/maven2/io/trino/trino-jdbc/363/trino-jdbc-363.jar mv trino-jdbc-363.jar trino chmod +x trino ./trino --version ``` ## Running the CLI The minimal command to start the CLI in interactive mode specifies the URL of the kyuubi server with the Trino protocol: ``` ./trino --server http://localhost:10999 ``` If successful, you will get a prompt to execute commands. Use the help command to see a list of supported commands. Use the clear command to clear the terminal. To stop and exit the CLI, run exit or quit.: ``` trino> help Supported commands: QUIT EXIT CLEAR EXPLAIN [ ( option [, ...] ) ] options: FORMAT { TEXT | GRAPHVIZ | JSON } TYPE { LOGICAL | DISTRIBUTED | VALIDATE | IO } DESCRIBE SHOW COLUMNS FROM SHOW FUNCTIONS SHOW CATALOGS [LIKE ] SHOW SCHEMAS [FROM ] [LIKE ] SHOW TABLES [FROM ] [LIKE ] USE [.] ``` You can now run SQL statements. After processing, the CLI will show results and statistics. ``` trino> select 1; _col0 ------- 1 (1 row) Query 20230216_125233_00806_examine_6hxus, FINISHED, 1 node Splits: 1 total, 1 done (100.00%) 0.29 [0 rows, 0B] [0 rows/s, 0B/s] trino> ``` Many other options are available to further configure the CLI in interactive mode to refer https://trino.io/docs/current/client/cli.html#running-the-cli