Starburst Enterprise Presto 338-e.6 Documentation

• 1. Overview
  • 1.1. Use Cases
  • 1.2. Presto Concepts
• 2. Installation
  • 2.1. Download
  • 2.2. Starburst Enterprise Presto license
  • 2.3. Deploying Presto
  • 2.4. Docker Container
  • 2.5. RPM Package and Presto Admin
  • 2.6. Microsoft Azure
  • 2.7. Presto Verifier
  • 2.8. Benchmark Driver
• 3. Clients
  • 3.1. Command Line Interface
  • 3.2. JDBC Driver
  • 3.3. Starburst JDBC Driver
  • 3.4. Starburst ODBC Driver
  • 3.5. Tableau
  • 3.6. Starburst Power BI DirectQuery Driver
• 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
  • 8.1. Web UI
  • 8.2. Tuning Presto
  • 8.3. Monitoring with JMX
  • 8.4. Properties Reference
  • 8.5. Spill to Disk
  • 8.6. Resource Groups
  • 8.7. Session Property Managers
  • 8.8. Distributed Sort
  • 8.9. Usage Metrics
• 9. Query Optimizer
  • 9.1. Table Statistics
  • 9.2. Cost in EXPLAIN
  • 9.3. Cost based optimizations
• 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
  • 12.1. Data Types
  • 12.2. Reserved Keywords
  • 12.3. Legacy and New Timestamp
• 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
  • 14.1. Migrating From Hive
• 15. Developer Guide
  • 15.1. SPI Overview
  • 15.2. Connectors
  • 15.3. Example HTTP Connector
  • 15.4. Types
  • 15.5. Functions
  • 15.6. System Access Control
  • 15.7. Password Authenticator
  • 15.8. Certificate Authenticator
  • 15.9. Group Provider
  • 15.10. Event Listener
• 16. Versions
  • 16.1. List of versions
  • 16.2. LTS and STS
  • 16.3. All releases
• 17. Release Notes
  • 17.1. Starburst Enterprise Presto Releases
  • 17.2. Recent Presto releases
  • 17.3. Older Presto releases