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
Cluster Management
SQL
Migrations
- Accumulo Connector
- Black Hole Connector
- Cassandra Connector
- Hive Connector
- Hive Security Configuration
- JMX Connector
- Kafka Connector
- Kafka Connector Tutorial
- Kinesis Connector
- Local File Connector
- Memory Connector
- MongoDB Connector
- MySQL Connector
- PostgreSQL Connector
- Redis Connector
- Redshift Connector
- SQL Server Connector
- System Connector
- Thrift Connector
- TPCDS Connector
- TPCH Connector
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.
- Presto UDFs.
Functions and Operators from the open-source
- Logical Operators
- Comparison Functions and Operators
- Conditional Expressions
- Lambda Expressions
- Conversion Functions
- Mathematical Functions and Operators
- Bitwise Functions
- Decimal Functions and Operators
- String Functions and Operators
- Regular Expression Functions
- Binary Functions and Operators
- JSON Functions and Operators
- Date and Time Functions and Operators
- Aggregate Functions
- Window Functions
- Array Functions and Operators
- Map Functions and Operators
- URL Functions
- Geospatial Functions
- Color Functions
- Session Information
- Teradata Functions
SQL Statement Syntax from Qubole
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
Cluster Management
SQL
Migrations
- Accumulo Connector
- Black Hole Connector
- BigQuery Connector
- Cassandra Connector
- Druid Connector
- Elasticsearch Connector
- Hive Connector
- Hive Connector GCS Tutorial
- Hive Security Configuration
- JMX Connector
- Kafka Connector
- Kafka Connector Tutorial
- Kinesis Connector
- Kudu Connector
- Local File Connector
- Memory Connector
- MongoDB Connector
- MySQL Connector
- Phoenix Connector
- PostgreSQL Connector
- Redis Connector
- Redshift Connector
- SQL Server Connector
- System Connector
- Thrift Connector
- TPCDS Connector
- TPCH Connector
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.
- Presto UDFs.
Functions and Operators from the open-source
- Logical Operators
- Comparison Functions and Operators
- Conditional Expressions
- Lambda Expressions
- Conversion Functions
- Mathematical Functions and Operators
- Bitwise Functions
- Decimal Functions and Operators
- String Functions and Operators
- Regular Expression Functions
- Binary Functions and Operators
- JSON Functions and Operators
- Date and Time Functions and Operators
- Aggregate Functions
- Window Functions
- Array Functions and Operators
- Map Functions and Operators
- URL Functions
- Geospatial Functions
- HyperLogLog Functions
- Quantile Digest Functions
- UUID Functions
- Color Functions
- Session Information
- Teradata Functions
SQL Statement Syntax from Qubole
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