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
- Secure internal communication
- Secrets
- Administration
- Event listeners
- Query optimizer
- Connectors
- Functions and operators
- 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
- List of functions and operators
- List of functions by topic
- SQL language
- SQL statement syntax
- ALTER MATERIALIZED VIEW
- ALTER SCHEMA
- ALTER TABLE
- ALTER VIEW
- ANALYZE
- CALL
- COMMENT
- COMMIT
- CREATE MATERIALIZED VIEW
- CREATE ROLE
- CREATE SCHEMA
- CREATE TABLE
- CREATE TABLE AS
- CREATE VIEW
- DEALLOCATE PREPARE
- DELETE
- DESCRIBE
- DESCRIBE INPUT
- DESCRIBE OUTPUT
- DROP MATERIALIZED VIEW
- DROP ROLE
- DROP SCHEMA
- DROP TABLE
- DROP VIEW
- EXECUTE
- EXPLAIN
- EXPLAIN ANALYZE
- GRANT
- GRANT ROLES
- INSERT
- MATCH_RECOGNIZE
- MERGE
- Row pattern recognition in window structures
- PREPARE
- REFRESH MATERIALIZED VIEW
- RESET SESSION
- REVOKE
- REVOKE ROLES
- ROLLBACK
- SELECT
- SET ROLE
- SET SESSION
- 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
- Developer guide
- Appendix