Trino documentation#
- Overview
- Installation
- Clients
- 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
- Open Policy Agent access control
- Ranger access control
- Secure internal communication
- Secrets
- Administration
- Web UI
- Preview Web UI
- Tuning Trino
- Monitoring with JMX
- Observability with OpenTelemetry
- Spill to disk
- Resource groups
- Session property managers
- Distributed sort
- Dynamic filtering
- Graceful shutdown
- Fault-tolerant execution
- HTTP event listener
- Kafka event listener
- MySQL event listener
- OpenLineage event listener
- Query optimizer
- Connectors
- BigQuery
- Black Hole
- Cassandra
- ClickHouse
- Delta Lake
- Druid
- Elasticsearch
- Exasol
- Faker
- Google Sheets
- Hive
- Hudi
- Iceberg
- Ignite
- JMX
- Kafka
- Kinesis
- Kudu
- MariaDB
- Memory
- MongoDB
- MySQL
- OpenSearch
- Oracle
- Phoenix
- Pinot
- PostgreSQL
- Prometheus
- Redis
- Redshift
- SingleStore
- Snowflake
- SQL Server
- System
- Thrift
- TPC-DS
- TPC-H
- Vertica
- Object storage
- 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
- User-defined functions
- SQL language
- 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 FUNCTION
- 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
- Developer guide
- SPI overview
- Test writing guidelines
- Connectors
- Example HTTP connector
- Example JDBC connector
- Supporting
INSERTandCREATE 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