Presto Documentation#
- 1. Overview
- 2. Installation
- 3. Security
- 4. Administration
- 5. Query Optimizer
- 6. Connectors
- 6.1. Accumulo Connector
- 6.2. BigQuery Connector
- 6.3. Black Hole Connector
- 6.4. Cassandra Connector
- 6.5. Elasticsearch Connector
- 6.6. Google Sheets Connector
- 6.7. Hive Connector
- 6.8. Hive Connector GCS Tutorial
- 6.9. Hive Security Configuration
- 6.10. JMX Connector
- 6.11. Kafka Connector
- 6.12. Kafka Connector Tutorial
- 6.13. Kinesis Connector
- 6.14. Kudu Connector
- 6.15. Local File Connector
- 6.16. Memory Connector
- 6.17. MemSQL Connector
- 6.18. MongoDB Connector
- 6.19. MySQL Connector
- 6.20. Oracle Connector
- 6.21. Phoenix Connector
- 6.22. Pinot Connector
- 6.23. PostgreSQL Connector
- 6.24. Prometheus Connector
- 6.25. Redis Connector
- 6.26. Redshift Connector
- 6.27. SQL Server Connector
- 6.28. System Connector
- 6.29. Thrift Connector
- 6.30. TPCDS Connector
- 6.31. TPCH Connector
- 7. Functions and Operators
- 7.1. Logical Operators
- 7.2. Comparison Functions and Operators
- 7.3. Conditional Expressions
- 7.4. Lambda Expressions
- 7.5. Conversion Functions
- 7.6. Mathematical Functions and Operators
- 7.7. Bitwise Functions
- 7.8. Decimal Functions and Operators
- 7.9. String Functions and Operators
- 7.10. Regular Expression Functions
- 7.11. Binary Functions and Operators
- 7.12. JSON Functions and Operators
- 7.13. Date and Time Functions and Operators
- 7.14. Aggregate Functions
- 7.15. Window Functions
- 7.16. Array Functions and Operators
- 7.17. Map Functions and Operators
- 7.18. URL Functions
- 7.19. Geospatial Functions
- 7.20. HyperLogLog Functions
- 7.21. Quantile Digest Functions
- 7.22. UUID Functions
- 7.23. Color Functions
- 7.24. Session Information
- 7.25. Teradata Functions
- 7.26. Machine Learning Functions
- 7.27. List of Functions and Operators
- 8. SQL Language
- 9. SQL Statement Syntax
- 9.1. ALTER SCHEMA
- 9.2. ALTER TABLE
- 9.3. ALTER VIEW
- 9.4. ANALYZE
- 9.5. CALL
- 9.6. COMMENT
- 9.7. COMMIT
- 9.8. CREATE ROLE
- 9.9. CREATE SCHEMA
- 9.10. CREATE TABLE
- 9.11. CREATE TABLE AS
- 9.12. CREATE VIEW
- 9.13. DEALLOCATE PREPARE
- 9.14. DELETE
- 9.15. DESCRIBE
- 9.16. DESCRIBE INPUT
- 9.17. DESCRIBE OUTPUT
- 9.18. DROP ROLE
- 9.19. DROP SCHEMA
- 9.20. DROP TABLE
- 9.21. DROP VIEW
- 9.22. EXECUTE
- 9.23. EXPLAIN
- 9.24. EXPLAIN ANALYZE
- 9.25. GRANT
- 9.26. GRANT ROLES
- 9.27. INSERT
- 9.28. PREPARE
- 9.29. RESET SESSION
- 9.30. REVOKE
- 9.31. REVOKE ROLES
- 9.32. ROLLBACK
- 9.33. SELECT
- 9.34. SET ROLE
- 9.35. SET SESSION
- 9.36. SHOW CATALOGS
- 9.37. SHOW COLUMNS
- 9.38. SHOW CREATE SCHEMA
- 9.39. SHOW CREATE TABLE
- 9.40. SHOW CREATE VIEW
- 9.41. SHOW FUNCTIONS
- 9.42. SHOW GRANTS
- 9.43. SHOW ROLE GRANTS
- 9.44. SHOW ROLES
- 9.45. SHOW SCHEMAS
- 9.46. SHOW SESSION
- 9.47. SHOW STATS
- 9.48. SHOW TABLES
- 9.49. START TRANSACTION
- 9.50. USE
- 9.51. VALUES
- 10. Migration
- 11. Developer Guide
- 12. Release Notes
- 12.1. Release 336 (16 Jun 2020)
- 12.2. Release 335 (14 Jun 2020)
- 12.3. Release 334 (29 May 2020)
- 12.4. Release 333 (04 May 2020)
- 12.5. Release 332 (08 Apr 2020)
- 12.6. Release 331 (16 Mar 2020)
- 12.7. Release 330 (18 Feb 2020)
- 12.8. Release 329 (23 Jan 2020)
- 12.9. Release 328 (10 Jan 2020)
- 12.10. Release 327 (20 Dec 2019)
- 12.11. Release 326 (27 Nov 2019)
- 12.12. Release 325 (14 Nov 2019)
- 12.13. Release 324 (1 Nov 2019)
- 12.14. Release 323 (23 Oct 2019)
- 12.15. Release 322 (16 Oct 2019)
- 12.16. Release 321 (15 Oct 2019)
- 12.17. Release 320 (10 Oct 2019)
- 12.18. Release 319 (22 Sep 2019)
- 12.19. Release 318 (26 Aug 2019)
- 12.20. Release 317 (1 Aug 2019)
- 12.21. Release 316 (8 Jul 2019)
- 12.22. Release 315 (14 Jun 2019)
- 12.23. Release 314
- 12.24. Release 313
- 12.25. Release 312
- 12.26. Release 311
- 12.27. Release 310
- 12.28. Release 309
- 12.29. Release 308
- 12.30. Release 307
- 12.31. Release 306
- 12.32. Release 305
- 12.33. Release 304
- 12.34. Release 303
- 12.35. Release 302
- 12.36. Release 301
- 12.37. Release 300
- 12.38. Release 0.215
- 12.39. Release 0.214
- 12.40. Release 0.213
- 12.41. Release 0.212
- 12.42. Release 0.211
- 12.43. Release 0.210
- 12.44. Release 0.209
- 12.45. Release 0.208
- 12.46. Release 0.207
- 12.47. Release 0.206
- 12.48. Release 0.205
- 12.49. Release 0.204
- 12.50. Release 0.203
- 12.51. Release 0.202
- 12.52. Release 0.201
- 12.53. Release 0.200
- 12.54. Release 0.199
- 12.55. Release 0.198
- 12.56. Release 0.197
- 12.57. Release 0.196
- 12.58. Release 0.195
- 12.59. Release 0.194
- 12.60. Release 0.193
- 12.61. Release 0.192
- 12.62. Release 0.191
- 12.63. Release 0.190
- 12.64. Release 0.189
- 12.65. Release 0.188
- 12.66. Release 0.187
- 12.67. Release 0.186
- 12.68. Release 0.185
- 12.69. Release 0.184
- 12.70. Release 0.183
- 12.71. Release 0.182
- 12.72. Release 0.181
- 12.73. Release 0.180
- 12.74. Release 0.179
- 12.75. Release 0.178
- 12.76. Release 0.177
- 12.77. Release 0.176
- 12.78. Release 0.175
- 12.79. Release 0.174
- 12.80. Release 0.173
- 12.81. Release 0.172
- 12.82. Release 0.171
- 12.83. Release 0.170
- 12.84. Release 0.169
- 12.85. Release 0.168
- 12.86. Release 0.167
- 12.87. Release 0.166
- 12.88. Release 0.165
- 12.89. Release 0.164
- 12.90. Release 0.163
- 12.91. Release 0.162
- 12.92. Release 0.161
- 12.93. Release 0.160
- 12.94. Release 0.159
- 12.95. Release 0.158
- 12.96. Release 0.157.1
- 12.97. Release 0.157
- 12.98. Release 0.156
- 12.99. Release 0.155
- 12.100. Release 0.154
- 12.101. Release 0.153
- 12.102. Release 0.152.3
- 12.103. Release 0.152.2
- 12.104. Release 0.152.1
- 12.105. Release 0.152
- 12.106. Release 0.151
- 12.107. Release 0.150
- 12.108. Release 0.149
- 12.109. Release 0.148
- 12.110. Release 0.147
- 12.111. Release 0.146
- 12.112. Release 0.145
- 12.113. Release 0.144.7
- 12.114. Release 0.144.6
- 12.115. Release 0.144.5
- 12.116. Release 0.144.4
- 12.117. Release 0.144.3
- 12.118. Release 0.144.2
- 12.119. Release 0.144.1
- 12.120. Release 0.144
- 12.121. Release 0.143
- 12.122. Release 0.142
- 12.123. Release 0.141
- 12.124. Release 0.140
- 12.125. Release 0.139
- 12.126. Release 0.138
- 12.127. Release 0.137
- 12.128. Release 0.136
- 12.129. Release 0.135
- 12.130. Release 0.134
- 12.131. Release 0.133
- 12.132. Release 0.132
- 12.133. Release 0.131
- 12.134. Release 0.130
- 12.135. Release 0.129
- 12.136. Release 0.128
- 12.137. Release 0.127
- 12.138. Release 0.126
- 12.139. Release 0.125
- 12.140. Release 0.124
- 12.141. Release 0.123
- 12.142. Release 0.122
- 12.143. Release 0.121
- 12.144. Release 0.120
- 12.145. Release 0.119
- 12.146. Release 0.118
- 12.147. Release 0.117
- 12.148. Release 0.116
- 12.149. Release 0.115
- 12.150. Release 0.114
- 12.151. Release 0.113
- 12.152. Release 0.112
- 12.153. Release 0.111
- 12.154. Release 0.110
- 12.155. Release 0.109
- 12.156. Release 0.108
- 12.157. Release 0.107
- 12.158. Release 0.106
- 12.159. Release 0.105
- 12.160. Release 0.104
- 12.161. Release 0.103
- 12.162. Release 0.102
- 12.163. Release 0.101
- 12.164. Release 0.100
- 12.165. Release 0.99
- 12.166. Release 0.98
- 12.167. Release 0.97
- 12.168. Release 0.96
- 12.169. Release 0.95
- 12.170. Release 0.94
- 12.171. Release 0.93
- 12.172. Release 0.92
- 12.173. Release 0.91
- 12.174. Release 0.90
- 12.175. Release 0.89
- 12.176. Release 0.88
- 12.177. Release 0.87
- 12.178. Release 0.86
- 12.179. Release 0.85
- 12.180. Release 0.84
- 12.181. Release 0.83
- 12.182. Release 0.82
- 12.183. Release 0.81
- 12.184. Release 0.80
- 12.185. Release 0.79
- 12.186. Release 0.78
- 12.187. Release 0.77
- 12.188. Release 0.76
- 12.189. Release 0.75
- 12.190. Release 0.74
- 12.191. Release 0.73
- 12.192. Release 0.72
- 12.193. Release 0.71
- 12.194. Release 0.70
- 12.195. Release 0.69
- 12.196. Release 0.68
- 12.197. Release 0.67
- 12.198. Release 0.66
- 12.199. Release 0.65
- 12.200. Release 0.64
- 12.201. Release 0.63
- 12.202. Release 0.62
- 12.203. Release 0.61
- 12.204. Release 0.60
- 12.205. Release 0.59
- 12.206. Release 0.58
- 12.207. Release 0.57
- 12.208. Release 0.56
- 12.209. Release 0.55
- 12.210. Release 0.54