Presto¶

This section explains how to configure and use Presto on a Qubole cluster. The configuration and usage are also categorized based on the two stable Presto versions.

Presto Configuration in QDS
Monitoring
External Data Source Access
- Accessing Data Stores through Presto Clusters
- Connecting to MySQL and JDBC Sources using Presto Clusters
Cluster Management
SQL
- JOIN Optimizations
- Strict Mode for Presto Queries
Migrations
- Migrating to Recent Presto Versions
- Migrating to Presto from Hive
Presto Best Practices
Using the Presto Query Retrying Mechanism
Using the Spill to Disk Mechanism

UDFs from Qubole
- Presto UDFs.
  
  Note
  
  You can use the Presto UDFs through a Presto Server bootstrap as described in Using Presto UDFs as a Bootstrap Script.
Functions and Operators from the open-source

SQL Statement Syntax from Qubole
- Inserting Data
- Insert Overwrite Into Directory
SQL Statement Syntax from Open Source
- ALTER SCHEMA
- ALTER TABLE
- CALL
- COMMIT
- CREATE SCHEMA
- CREATE TABLE
- CREATE TABLE AS
- CREATE VIEW
- DEALLOCATE PREPARE
- DELETE
- DESCRIBE
- DESCRIBE INPUT
- DESCRIBE OUTPUT
- DROP SCHEMA
- DROP TABLE
- DROP VIEW
- EXECUTE
- EXPLAIN
- EXPLAIN ANALYZE
- GRANT
- INSERT
- PREPARE
- RESET SESSION
- REVOKE
- ROLLBACK
- SELECT
- SET SESSION
- SHOW CATALOGS
- SHOW COLUMNS
- SHOW CREATE TABLE
- SHOW CREATE VIEW
- SHOW FUNCTIONS
- SHOW GRANTS
- SHOW SCHEMAS
- SHOW SESSION
- SHOW TABLES
- START TRANSACTION
- USE
- VALUES

Presto Configuration in QDS
Monitoring
External Data Source Access
- Accessing Data Stores through Presto Clusters
- Connecting to MySQL and JDBC Sources using Presto Clusters
Cluster Management
SQL
- JOIN Optimizations
- Strict Mode for Presto Queries
Migrations
- Migrating to Recent Presto Versions
- Migrating to Presto from Hive
Presto Best Practices
Using the Presto Query Retrying Mechanism
Using the Spill to Disk Mechanism

UDFs from Qubole
- Presto UDFs.
  
  Note
  
  You can use the Presto UDFs through a Presto Server bootstrap as described in Using Presto UDFs as a Bootstrap Script.
Functions and Operators from the open-source

SQL Statement Syntax from Qubole
- Inserting Data
- Insert Overwrite Into Directory
SQL Statement Syntax from Open Source
- ALTER SCHEMA
- ALTER TABLE
- ANALYZE
- CALL
- COMMENT
- COMMIT
- CREATE ROLE
- CREATE SCHEMA
- CREATE TABLE
- CREATE TABLE AS
- CREATE VIEW
- DEALLOCATE PREPARE
- DELETE
- DESCRIBE
- DESCRIBE INPUT
- DESCRIBE OUTPUT
- DROP ROLE
- DROP SCHEMA
- DROP TABLE
- DROP VIEW
- EXECUTE
- EXPLAIN
- EXPLAIN ANALYZE
- GRANT
- GRANT ROLES
- INSERT
- PREPARE
- RESET SESSION
- REVOKE
- REVOKE ROLES
- ROLLBACK
- SELECT
- SET ROLE
- SET SESSION
- SHOW CATALOGS
- SHOW COLUMNS
- 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
- USE
- VALUES

What’s New in Presto
Next generation (v3.0) Presto JDBC drivers Presto 317 is now Generally Available Introducing operational governance, concurrency scaling capabilities for ad hoc workloads Improvements to Presto dynamic filtering Enhancements in Presto for next gen JDBC, ODBC drivers that are faster, have more functionality