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 syntax
- ALTER MATERIALIZED VIEW
- ALTER SCHEMA
- ALTER TABLE
- ALTER VIEW
- ANALYZE
- CALL
- COMMENT
- Comments
- COMMIT
- CREATE MATERIALIZED VIEW
- CREATE ROLE
- CREATE SCHEMA
- CREATE TABLE
- CREATE TABLE AS
- CREATE VIEW
- DEALLOCATE PREPARE
- DELETE
- DENY
- DESCRIBE
- DESCRIBE INPUT
- DESCRIBE OUTPUT
- DROP MATERIALIZED VIEW
- DROP ROLE
- DROP SCHEMA
- DROP TABLE
- DROP VIEW
- EXECUTE
- EXECUTE IMMEDIATE
- EXPLAIN
- EXPLAIN ANALYZE
- GRANT
- GRANT ROLES
- INSERT
- MATCH_RECOGNIZE
- MERGE
- Row pattern recognition in window structures
- PREPARE
- REFRESH MATERIALIZED VIEW
- RESET SESSION
- RESET SESSION AUTHORIZATION
- REVOKE
- REVOKE ROLES
- 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
- 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