Trino documentation

• Overview
  • Use cases
  • Trino concepts
• Installation
  • Deploying Trino
  • Trino in a Docker container
  • Trino on Kubernetes with Helm
  • RPM package
  • Improve query processing resilience
• Clients
  • Command line interface
  • JDBC driver
• Security
  • Security overview
  • TLS and HTTPS
  • PEM files
  • JKS files
  • Authentication types
  • Password file authentication
  • LDAP authentication
  • Salesforce authentication
  • OAuth 2.0 authentication
  • Kerberos authentication
  • Certificate authentication
  • JWT authentication
  • User mapping
  • File group provider
  • System access control
  • File-based access control
  • Secure internal communication
  • Secrets
• Administration
  • Web UI
  • Tuning Trino
  • Monitoring with JMX
  • Properties reference
    • General
    • Resource management
    • Query management
    • Catalog management
    • SQL environment
    • Spilling
    • Exchange
    • Task
    • Write partitioning
    • Writer scaling
    • Node scheduler
    • Optimizer
    • Logging
    • Web UI
    • Regular expression function
    • HTTP client
  • Spill to disk
  • Resource groups
  • Session property managers
  • Distributed sort
  • Dynamic filtering
  • Graceful shutdown
  • Fault-tolerant execution
  • HTTP event listener
  • MySQL event listener
• Query optimizer
  • Table statistics
  • Cost in EXPLAIN
  • Cost-based optimizations
  • Pushdown
• Connectors
  • Accumulo
  • Atop
  • BigQuery
  • Black Hole
  • Cassandra
  • ClickHouse
  • Delta Lake
  • Druid
  • Elasticsearch
  • Google Sheets
  • Hive
  • Hudi
  • Iceberg
  • Ignite
  • JMX
  • Kafka
  • Kinesis
  • Kudu
  • Local File
  • MariaDB
  • Memory
  • MongoDB
  • MySQL
  • Oracle
  • Phoenix
  • Pinot
  • PostgreSQL
  • Prometheus
  • Redis
  • Redshift
  • SingleStore
  • SQL Server
  • StarRocks
  • System
  • Thrift
  • TPCDS
  • TPCH
• Functions and operators
  • List of functions and operators
  • List of functions by topic
  • Aggregate
  • Array
  • Binary
  • Bitwise
  • Color
  • Comparison
  • Conditional
  • Conversion
  • Date and time
  • Decimal
  • Geospatial
  • HyperLogLog
  • IP Address
  • JSON
  • Lambda
  • Logical
  • Machine learning
  • Map
  • Math
  • Quantile digest
  • Regular expression
  • Session
  • Set Digest
  • String
  • System
  • Table
  • Teradata
  • T-Digest
  • URL
  • UUID
  • Window
• SQL language
  • SQL statement support
  • Data types
  • Keywords and identifiers
  • Comments
• SQL statement syntax
  • ALTER MATERIALIZED VIEW
  • ALTER SCHEMA
  • ALTER TABLE
  • ALTER VIEW
  • ANALYZE
  • CALL
  • COMMENT
  • COMMIT
  • CREATE CATALOG
  • CREATE FUNCTION
  • CREATE MATERIALIZED VIEW
  • CREATE ROLE
  • CREATE SCHEMA
  • CREATE TABLE
  • CREATE TABLE AS
  • CREATE VIEW
  • DEALLOCATE PREPARE
  • DELETE
  • DENY
  • DESCRIBE
  • DESCRIBE INPUT
  • DESCRIBE OUTPUT
  • DROP CATALOG
  • DROP FUNCTION
  • DROP MATERIALIZED VIEW
  • DROP ROLE
  • DROP SCHEMA
  • DROP TABLE
  • DROP VIEW
  • EXECUTE
  • EXECUTE IMMEDIATE
  • EXPLAIN
  • EXPLAIN ANALYZE
  • GRANT privilege
  • GRANT role
  • INSERT
  • MATCH_RECOGNIZE
  • MERGE
  • PREPARE
  • REFRESH MATERIALIZED VIEW
  • RESET SESSION
  • RESET SESSION AUTHORIZATION
  • REVOKE privilege
  • REVOKE role
  • ROLLBACK
  • SELECT
  • SET PATH
  • SET ROLE
  • SET SESSION
  • SET SESSION AUTHORIZATION
  • SET TIME ZONE
  • SHOW CATALOGS
  • SHOW COLUMNS
  • SHOW CREATE MATERIALIZED VIEW
  • SHOW CREATE SCHEMA
  • SHOW CREATE TABLE
  • SHOW CREATE VIEW
  • SHOW FUNCTIONS
  • SHOW GRANTS
  • SHOW ROLE GRANTS
  • SHOW ROLES
  • SHOW SCHEMAS
  • SHOW SESSION
  • SHOW STATS
  • SHOW TABLES
  • START TRANSACTION
  • TRUNCATE
  • UPDATE
  • USE
  • VALUES
• SQL routines
  • Introduction
  • Examples
  • BEGIN
  • CASE
  • DECLARE
  • FUNCTION
  • IF
  • ITERATE
  • LEAVE
  • LOOP
  • REPEAT
  • RETURN
  • SET
  • WHILE
• Developer guide
  • SPI overview
  • Connectors
  • Example HTTP connector
  • Example JDBC connector
  • Supporting INSERT and CREATE TABLE AS
  • Supporting MERGE
  • Types
  • Functions
  • Table functions
  • System access control
  • Password authenticator
  • Certificate authenticator
  • Header authenticator
  • Group provider
  • Event listener
  • Trino client REST API
• Glossary
• Appendix
  • Migrating from Hive
  • Legal notices

• Release notes