Starburst Enterprise Presto Documentation#
- 1. Overview
- 2. Installation
- 3. Clients
- 4. Amazon Web Services
- 4.1. Getting Started on AWS
- 4.2. Overview
- 4.3. Prerequisites
- 4.4. Deploying Presto
- 4.5. Configuring Presto
- 4.6. Configuring Hive Metastore
- 4.7. Accessing the Presto Cluster
- 4.8. Querying Presto
- 4.9. Querying AWS S3
- 4.10. AWS Glue Support
- 4.11. Using Apache Superset
- 4.12. Manual Scaling a Running Presto Cluster
- 4.13. Auto Scaling a Presto Cluster
- 4.14. Coordinator High Availability
- 4.15. Secrets
- 4.16. Integration with CloudWatch Logs
- 4.17. Integration with CloudWatch Metrics
- 4.18. Troubleshooting
- 4.19. Uninstalling Presto
- 4.20. AWS AMI/CFT Release Notes
- 5. Kubernetes with Helm
- 5.1. Overview
- 5.2. Requirements
- 5.3. Installation
- 5.4. SEP configuration
- 5.5. Hive metastore configuration
- 5.6. Ranger configuration
- 5.7. Operation
- 5.8. Helm chart release notes
- 5.9. Amazon Elastic Kubernetes Service
- 5.10. Google Kubernetes Engine
- 5.11. Microsoft Azure Kubernetes Service
- 5.12. Red Hat OpenShift
- 6. Kubernetes operator
- 6.1. Overview
- 6.2. Prerequisites
- 6.3. Deployment of Presto on Kubernetes
- 6.4. Presto Kubernetes Resource
- 6.5. Querying Presto
- 6.6. Customizing Presto Docker Images
- 6.7. Horizontal Scaling
- 6.8. Secrets
- 6.9. Ranger
- 6.10. Using Amazon Elastic Kubernetes Service
- 6.11. GCP Marketplace
- 6.12. Using Google Kubernetes Engine
- 6.13. Azure Marketplace
- 6.14. Using Microsoft Azure Kubernetes Service
- 6.15. Using Red Hat OpenShift
- 6.16. Kubernetes Resources Release Notes
- 7. Security
- 7.1. Coordinator Kerberos Authentication
- 7.2. CLI Kerberos Authentication
- 7.3. LDAP Authentication
- 7.4. Password File Authentication
- 7.5. User Mapping
- 7.6. Java Keystores and Truststores
- 7.7. Built-in System Access Control
- 7.8. LDAP group provider
- 7.9. Secrets
- 7.10. Secure Internal Communication
- 7.11. Query audit
- 7.12. Event Logger
- 7.13. Role Based Access Control
- 7.14. System level security with Apache Ranger
- 7.15. Hive level security with Apache Ranger
- 7.16. Hive level security with Apache Sentry
- 7.17. User Impersonation
- 7.18. Kerberos Credential Passthrough
- 7.19. Okta authentication
- 8. Administration
- 9. Query Optimizer
- 10. Connectors
- 10.1. Starburst Connectors Overview
- 10.2. Starburst DB2 Connector (license required)
- 10.3. Starburst Generic JDBC Connector
- 10.4. Starburst Hive Connector
- 10.5. Starburst Hive Connector Security
- 10.6. IBM Cloud Object Storage Support for the Hive Connector
- 10.7. MapR Hive metastore (license required)
- 10.8. Cloudera Data Platform support (license required)
- 10.9. Starburst Delta Lake Connector (license required)
- 10.10. Starburst Kafka Connector
- 10.11. Starburst MySQL Connector
- 10.12. Starburst Oracle Connector (license required)
- 10.13. Starburst PostgreSQL Connector
- 10.14. Starburst Snowflake Connector (license required)
- 10.15. Starburst SQL Server Connector
- 10.16. Starburst Teradata Connector (license required)
- 10.17. Starburst Teradata Parallel Direct Connector (license required)
- 10.18. Accumulo Connector
- 10.19. BigQuery Connector
- 10.20. Black Hole Connector
- 10.21. Cassandra Connector
- 10.22. Druid Connector
- 10.23. Elasticsearch Connector
- 10.24. Google Sheets Connector
- 10.25. Hive Connector
- 10.26. Hive Connector GCS Tutorial
- 10.27. Hive Security Configuration
- 10.28. Hive Connector Storage Caching
- 10.29. Hive Connector with Azure Storage
- 10.30. Hive Connector with Alluxio
- 10.31. JMX Connector
- 10.32. Kafka Connector
- 10.33. Kafka Connector Tutorial
- 10.34. Kinesis Connector
- 10.35. Kudu Connector
- 10.36. Local File Connector
- 10.37. Memory Connector
- 10.38. MongoDB Connector
- 10.39. MemSQL Connector
- 10.40. MySQL Connector
- 10.41. Oracle Connector
- 10.42. Phoenix Connector
- 10.43. Pinot Connector
- 10.44. PostgreSQL Connector
- 10.45. Prometheus Connector
- 10.46. Redis Connector
- 10.47. Redshift Connector
- 10.48. SQL Server Connector
- 10.49. System Connector
- 10.50. Thrift Connector
- 10.51. TPCDS Connector
- 10.52. TPCH Connector
- 11. Functions and Operators
- 11.1. Logical Operators
- 11.2. Comparison Functions and Operators
- 11.3. Conditional Expressions
- 11.4. Lambda Expressions
- 11.5. Conversion Functions
- 11.6. Mathematical Functions and Operators
- 11.7. Bitwise Functions
- 11.8. Decimal Functions and Operators
- 11.9. String Functions and Operators
- 11.10. Regular Expression Functions
- 11.11. Binary Functions and Operators
- 11.12. JSON Functions and Operators
- 11.13. Date and Time Functions and Operators
- 11.14. Aggregate Functions
- 11.15. Window Functions
- 11.16. Array Functions and Operators
- 11.17. Map Functions and Operators
- 11.18. URL Functions
- 11.19. Geospatial Functions
- 11.20. HyperLogLog Functions
- 11.21. Quantile Digest Functions
- 11.22. UUID Functions
- 11.23. Color Functions
- 11.24. Session Information
- 11.25. Teradata Functions
- 11.26. Oracle Functions
- 11.27. Machine Learning Functions
- 11.28. List of Functions and Operators
- 12. SQL Language
- 13. SQL Statement Syntax
- 13.1. ALTER SCHEMA
- 13.2. ALTER TABLE
- 13.3. ALTER VIEW
- 13.4. ANALYZE
- 13.5. CALL
- 13.6. COMMENT
- 13.7. COMMIT
- 13.8. CREATE ROLE
- 13.9. CREATE SCHEMA
- 13.10. CREATE TABLE
- 13.11. CREATE TABLE AS
- 13.12. CREATE VIEW
- 13.13. DEALLOCATE PREPARE
- 13.14. DELETE
- 13.15. DESCRIBE
- 13.16. DESCRIBE INPUT
- 13.17. DESCRIBE OUTPUT
- 13.18. DROP ROLE
- 13.19. DROP SCHEMA
- 13.20. DROP TABLE
- 13.21. DROP VIEW
- 13.22. EXECUTE
- 13.23. EXPLAIN
- 13.24. EXPLAIN ANALYZE
- 13.25. GRANT
- 13.26. GRANT ROLES
- 13.27. INSERT
- 13.28. PREPARE
- 13.29. RESET SESSION
- 13.30. REVOKE
- 13.31. REVOKE ROLES
- 13.32. ROLLBACK
- 13.33. SELECT
- 13.34. SET ROLE
- 13.35. SET SESSION
- 13.36. SHOW CATALOGS
- 13.37. SHOW COLUMNS
- 13.38. SHOW CREATE SCHEMA
- 13.39. SHOW CREATE TABLE
- 13.40. SHOW CREATE VIEW
- 13.41. SHOW FUNCTIONS
- 13.42. SHOW GRANTS
- 13.43. SHOW ROLE GRANTS
- 13.44. SHOW ROLES
- 13.45. SHOW SCHEMAS
- 13.46. SHOW SESSION
- 13.47. SHOW STATS
- 13.48. SHOW TABLES
- 13.49. START TRANSACTION
- 13.50. USE
- 13.51. VALUES
- 14. Migration
- 15. Developer Guide
- 16. Versions
- 17. Release Notes