Presto DocumentationΒΆ
- Overview
- Installation
- Presto Clients
- Security
- Administration
- Cache
- Query Optimizer
- Connectors
- Accumulo Connector
- BigQuery Connector
- Black Hole Connector
- Cassandra Connector
- ClickHouse connector
- Delta Lake Connector
- Druid Connector
- Elasticsearch Connector
- Google Sheets connector
- HANA Connector
- Hive Connector
- Hive Security Configuration
- Hudi Connector
- Iceberg Connector
- JMX Connector
- Kafka Connector
- Kafka Connector Tutorial
- Kudu Connector
- Lark Sheets connector
- Local File Connector
- Memory Connector
- MongoDB Connector
- MySQL Connector
- Oracle Connector
- Apache Pinot Connector
- PostgreSQL Connector
- Prometheus Connector
- Redis Connector
- Redshift Connector
- ScyllaDB Connector
- SingleStore Connector
- SQL Server Connector
- System Connector
- Thrift Connector
- TPCDS Connector
- TPCH Connector
- Plugins
- Functions and Operators
- 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
- Noisy Aggregate Functions
- Window Functions
- Array Functions and Operators
- Map Functions and Operators
- URL Functions
- IP Functions
- Geospatial Functions
- HyperLogLog Functions
- KHyperLogLog Functions
- Quantile Digest Functions
- UUID functions
- T-Digest Functions
- Color Functions
- Session Information
- Teradata Functions
- Internationalization Functions
- Set Digest functions
- Sketch Functions
- Pinot Functions
- SQL Language
- SQL Statement Syntax
- ALTER FUNCTION
- ALTER SCHEMA
- ALTER TABLE
- ANALYZE
- CALL
- COMMIT
- CREATE FUNCTION
- CREATE ROLE
- CREATE SCHEMA
- CREATE TABLE
- CREATE TABLE AS
- CREATE VIEW
- DEALLOCATE PREPARE
- DELETE
- DESCRIBE
- DESCRIBE INPUT
- DESCRIBE OUTPUT
- DROP FUNCTION
- 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 FUNCTION
- 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
- Migration
- REST API
- Ecosystem
- Router
- Developer Guide
- Presto C++
- Release Notes
- Release-0.288 [2024-06-13]
- Release-0.287 [2024-04-16]
- Release-0.286 [2024-02-12]
- Release-0.285.1 [2023-12-30]
- Release-0.285 [2023-12-08]
- Release-0.284 [2023-10-11]
- Release-0.283 [2023-08-08]
- Release 0.282
- Release 0.281
- Release 0.280
- Release 0.279.2
- Release 0.279
- Release 0.278.1
- Release 0.278
- Release 0.277
- Release 0.276.1
- Release 0.276
- Release 0.275
- Release 0.274
- Release 0.273.3
- Release 0.273.2
- Release 0.273
- Release 0.272
- Release 0.271
- Release 0.270
- Release 0.269
- Release 0.268
- Release 0.267
- Release 0.266
- Release 0.265
- Release 0.264.1
- Release 0.264
- Release 0.263.1
- Release 0.263
- Release 0.262
- Release 0.261
- Release 0.260.1
- Release 0.260
- Release 0.259.1
- Release 0.259
- Release 0.258
- Release 0.257
- Release 0.256
- Release 0.255
- Release 0.254.1
- Release 0.254
- Release 0.253.1
- Release 0.253
- Release 0.252
- Release 0.251.1
- Release 0.251
- Release 0.250
- Release 0.249.2
- Release 0.249.1
- Release 0.249
- Release 0.248.1
- Release 0.248
- Release 0.247
- Release 0.246
- Release 0.245.1
- Release 0.245
- Release 0.244.1
- Release 0.244
- Release 0.243.4
- Release 0.243.3
- Release 0.243.2
- Release 0.243.1
- Release 0.243
- Release 0.242.1
- Release 0.242
- Release 0.241
- Release 0.240
- Release 0.239.2
- Release 0.239.1
- Release 0.239
- Release 0.238.3
- Release 0.238.2
- Release 0.238
- Release 0.237
- Release 0.236
- Release 0.235.1
- Release 0.235
- Release 0.234.3
- Release 0.234.2
- Release 0.234.1
- Release 0.234
- Release 0.233.1
- Release 0.233
- Release 0.232
- Release 0.231
- Release 0.230
- Release 0.229
- Release 0.228
- Release 0.227
- Release 0.226
- Release 0.225
- Release 0.224
- Release 0.223
- Release 0.222
- Release 0.221
- Release 0.220
- Release 0.219
- Release 0.218
- Release 0.217
- Release 0.216
- Release 0.215
- Release 0.214
- Release 0.213
- Release 0.212
- Release 0.211
- Release 0.210
- Release 0.209
- Release 0.208
- Release 0.207
- Release 0.206
- Release 0.205
- Release 0.204
- Release 0.203
- Release 0.202
- Release 0.201
- Release 0.200
- Release 0.199
- Release 0.198
- Release 0.197
- Release 0.196
- Release 0.195
- Release 0.194
- Release 0.193
- Release 0.192
- Release 0.191
- Release 0.190
- Release 0.189
- Release 0.188
- Release 0.187
- Release 0.186
- Release 0.185
- Release 0.184
- Release 0.183
- Release 0.182
- Release 0.181
- Release 0.180
- Release 0.179
- Release 0.178
- Release 0.177
- Release 0.176
- Release 0.175
- Release 0.174
- Release 0.173
- Release 0.172
- Release 0.171
- Release 0.170
- Release 0.169
- Release 0.168
- Release 0.167
- Release 0.166
- Release 0.165
- Release 0.164
- Release 0.163
- Release 0.162
- Release 0.161
- Release 0.160
- Release 0.159
- Release 0.158
- Release 0.157.1
- Release 0.157
- Release 0.156
- Release 0.155
- Release 0.154
- Release 0.153
- Release 0.152.3
- Release 0.152.2
- Release 0.152.1
- Release 0.152
- Release 0.151
- Release 0.150
- Release 0.149
- Release 0.148
- Release 0.147
- Release 0.146
- Release 0.145
- Release 0.144.7
- Release 0.144.6
- Release 0.144.5
- Release 0.144.4
- Release 0.144.3
- Release 0.144.2
- Release 0.144.1
- Release 0.144
- Release 0.143
- Release 0.142
- Release 0.141
- Release 0.140
- Release 0.139
- Release 0.138
- Release 0.137
- Release 0.136
- Release 0.135
- Release 0.134
- Release 0.133
- Release 0.132
- Release 0.131
- Release 0.130
- Release 0.129
- Release 0.128
- Release 0.127
- Release 0.126
- Release 0.125
- Release 0.124
- Release 0.123
- Release 0.122
- Release 0.121
- Release 0.120
- Release 0.119
- Release 0.118
- Release 0.117
- Release 0.116
- Release 0.115
- Release 0.114
- Release 0.113
- Release 0.112
- Release 0.111
- Release 0.110
- Release 0.109
- Release 0.108
- Release 0.107
- Release 0.106
- Release 0.105
- Release 0.104
- Release 0.103
- Release 0.102
- Release 0.101
- Release 0.100
- Release 0.99
- Release 0.98
- Release 0.97
- Release 0.96
- Release 0.95
- Release 0.94
- Release 0.93
- Release 0.92
- Release 0.91
- Release 0.90
- Release 0.89
- Release 0.88
- Release 0.87
- Release 0.86
- Release 0.85
- Release 0.84
- Release 0.83
- Release 0.82
- Release 0.81
- Release 0.80
- Release 0.79
- Release 0.78
- Release 0.77
- Release 0.76
- Release 0.75
- Release 0.74
- Release 0.73
- Release 0.72
- Release 0.71
- Release 0.70
- Release 0.69
- Release 0.68
- Release 0.67
- Release 0.66
- Release 0.65
- Release 0.64
- Release 0.63
- Release 0.62
- Release 0.61
- Release 0.60
- Release 0.59
- Release 0.58
- Release 0.57
- Release 0.56
- Release 0.55
- Release 0.54