USER MANUALS

Presto CLI

The Presto CLI is a terminal-based interactive shell for running queries. It has been included in the Denodo Embedded MPP for easy query execution for debugging and testing.

To run queries you need to connect to a Presto pod, usually the MPP coordinator will be used.

kubectl exec -it <Coordinator Pod> -- bash

Start the Presto CLI using:

./opt/presto-cli/presto

Run the CLI with the --help option to see the available options.

The following is an example query to the region table from TPCH.

 presto> SELECT * FROM hive."default".region;
 regionkey |    name     |            comment
 ----------+-------------+-----------------------------------------------------------
         0 | AFRICA      | lar deposits. blithely final packages cajole. regular wate
         1 | AMERICA     | hs use ironic, even requests. s
         2 | ASIA        | ges. thinly even pinto beans ca
         3 | EUROPE      | ly final courts cajole furiously final excuse
         4 | MIDDLE EAST | uickly special accounts cajole carefully blithely close re
 (5 rows)

 Query 20241022_122442_00011_5zzxh, FINISHED, 2 nodes
 Splits: 17 total, 17 done (100.00%)
 [Latency: client-side: 0:02, server-side: 0:02] [5 rows, 1.52KB] [3 rows/s, 1023B/s]
Add feedback