Starburst Enterprise 397-e STS reference documentation

User guides

Our user guides have the latest information on how to get started with Starburst Enterprise platform (SEP), as well as in-depth video training on topics such as: Performance tuning Security Query tuning Advanced SQL

Let's go exploring!

Reference documentation

Use the left-hand menu to browse our reference documentation for the current SEP release, or select another version in the upper right.

• Overview
  • Use cases
  • Core concepts
  • Starburst Enterprise web UI
• Manual installation and license
  • Download
  • Starburst Enterprise license
  • RPM package
  • SEP Docker container
  • Trino Docker Container
  • Deploying Trino
• Deploying with Kubernetes
  • Starburst Enterprise with Kubernetes requirements
  • Installing Starburst Enterprise in a Kubernetes cluster
  • Configuring Starburst Enterprise in Kubernetes
  • Kubernetes configuration examples
  • Configuring the Hive Metastore Service in Kubernetes
  • Configuring Starburst Enterprise with Ranger in Kubernetes
  • Configure the cache service in Kubernetes
  • Helm chart release notes
• Deploying with CFT on AWS
  • Starburst Enterprise with CFT requirements
  • Installing Starburst Enterprise in AWS
  • Configuring Starburst Enterprise with CFT
  • Configuring the Hive Metastore Service with CFT
  • Configuring Starburst Enterprise with CloudWatch in CFT
  • AWS AMI/CFT release notes
• Clients
  • Command line interface
  • JDBC driver
  • Query editor
• Security
  • Security overview
  • TLS and HTTPS
  • - PEM files
  • - JKS files
  • Secure internal communication
  • Secrets
  • Authentication types
  • - Password files
  • - LDAP
  • - LDAP group provider
  • - Salesforce
  • - OAuth2 over HTTPS
  • - OAuth2 providers
  • - Okta
  • - Kerberos
  • - Certificate
  • - JWT
  • - Password pass-through
  • - OAuth 2.0 token pass-through
  • - Kerberos credential pass-through
  • Built-in access control overview
  • - Built-in access control roles
  • - Built-in access control privileges
  • - Built-in access control audit log
  • - Comparison to Apache Ranger
  • Apache Ranger overview
  • - Global Ranger
  • - Hive Ranger
  • - Global Privacera
  • - Hive Privacera
  • Immuta
  • Hive Sentry
  • AWS Lake Formation
  • System access control
  • File system access control
  • File-based group provider
  • User impersonation
  • User mapping
  • Query audit
• Administration
  • Trino web UI
  • Tuning Starburst Enterprise
  • Monitoring with JMX
  • Properties reference
    • General
    • Resource management
    • Query management
    • 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
  • Starburst Cached Views
  • Table scan redirection
  • Cache service
  • Cache service CLI
  • Atlas integration
  • Starburst Atlas plugin
  • Atlas CLI
  • Ranger Tagsync and Atlas
• Data products
  • Data products overview
  • Data product feature configuration
  • Data product dashboard
  • Manage data products
  • Data domain management
  • Markdown for data products descriptions and comments
  • Data products REST API
• Insights
  • Insights overview
  • Insights configuration
  • Insights query overview
  • Insights query details
  • Insights cluster history
  • Insights usage metrics
• Query optimizer
  • Table statistics
  • Pushdown
  • Cost based optimizations
  • Cost in EXPLAIN
  • Starburst optimizer properties
• Connectors
  • Starburst connectors overview
  • Starburst BigQuery connector
  • Starburst IBM DB2 connector
  • Starburst DynamoDB connector
  • Starburst Delta Lake connector
  • Starburst Generic JDBC connector
  • Starburst Greenplum connector
  • Starburst Hive connector
  • - IBM Cloud Object Storage support
  • - Cloudera Data Platform support
  • - MinIO storage support
  • Starburst Iceberg connector
  • Starburst Kafka connector
  • Starburst MySQL connector
  • Starburst Netezza connector
  • Starburst Oracle connector
  • Starburst PostgreSQL connector
  • Starburst Redshift connector
  • Starburst SAP HANA connector
  • Starburst Salesforce connector
  • Starburst SingleStore (MemSQL) connector
  • Starburst Snowflake connector
  • Starburst Splunk connector
  • Starburst SQL Server connector
  • Starburst Stargate
  • Starburst Synapse connector
  • Starburst Teradata connectors
  • Starburst Vertica connector
  • Accumulo connector
  • Atop connector
  • Black Hole connector
  • Cassandra connector
  • ClickHouse connector
  • Delta Lake connector
  • Druid connector
  • Elasticsearch connector
  • Google Sheets connector
  • JMX connector
  • Kinesis connector
  • Kudu connector
  • Local file connector
  • MariaDB connector
  • Memory connector
  • MongoDB connector
  • Phoenix connector
  • Pinot connector
  • Prometheus connector
  • Redis connector
  • System connector
  • Thrift connector
  • TPCDS connector
  • TPCH connector
• 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 support
  • Data types
  • Reserved keywords
• 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
  • SPI overview
  • Connectors
  • Example HTTP connector
  • Supporting INSERT and CREATE TABLE AS
  • Supporting DELETE and UPDATE
  • Supporting MERGE
  • Types
  • Functions
  • Table functions
  • System access control
  • Password authenticator
  • Certificate authenticator
  • Header authenticator
  • Group provider
  • Event listener
  • Trino client REST API
• Appendix
  • Glossary
  • Migrating from Hive
  • Migrating to Starburst Enterprise 354-e or higher
  • Migrating to Java 17 for Starburst Enterprise 390-e or higher
  • Legal notices
  • Third party dependencies

Version information

• 397-e STS and others
• Release notes