Run Query Trino

If no container exists:

docker run -d -p 8080:8080 --name trino trinodb/trino

If container exists but is stopped (you get a "name already in use" error):

docker start trino

Wait a few seconds for Trino to initialize before running queries.

Run a query

docker exec trino trino --execute 'SELECT * FROM tpch.tiny.region'

For queries with a specific catalog/schema:

docker exec trino trino --catalog tpch --schema tiny --execute 'SELECT * FROM region LIMIT 10'

Output formats

Default is aligned columns. For CSV output:

docker exec trino trino --output-format CSV --execute 'SELECT ...'

Available Catalogs

The default trinodb/trino image includes:

• tpch - TPC-H benchmark data (schemas: tiny, sf1, sf10, etc.)
• tpcds - TPC-DS benchmark data
• memory - In-memory tables
• system - System information

Example Queries

-- List available catalogs
SHOW CATALOGS;

-- List schemas in tpch
SHOW SCHEMAS FROM tpch;

-- List tables in tpch.tiny
SHOW TABLES FROM tpch.tiny;

-- Sample query
SELECT * FROM tpch.tiny.nation LIMIT 5;

-- Check cluster nodes
SELECT * FROM system.runtime.nodes;

Cleanup

To stop and remove the container:

docker stop trino && docker rm trino

When to Use This Skill

Load this skill when:

• The user asks to run a Trino query locally
• The user wants to test SQL against Trino
• The user mentions "run-query:trino"