Based on the Trino 466 release.

Starburst Galaxy SQL reference documentation

The Starburst Galaxy SQL reference documentation contains the syntax and other detailed information about SQL data types, statements, functions, and more.

Find more information about Starburst Galaxy including features such as the query editor, clusters, catalogs, and security as well as useful videos, tutorials, and troubleshooting information in the Starburst Galaxy documentation.

• 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 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 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 FUNCTION
  • 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
  • SQL entity kinds and privileges
  • START TRANSACTION
  • TRUNCATE
  • UPDATE
  • USE
  • VALUES
• 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 routines
  • Introduction
  • Examples
  • BEGIN
  • CASE
  • DECLARE
  • FUNCTION
  • IF
  • ITERATE
  • LEAVE
  • LOOP
  • REPEAT
  • RETURN
  • SET
  • WHILE