Presto Documentation
- 1. Overview
- 2. Installation
- 3. Security
- 4. Administration
- 5. Cache
- 6. Query Optimizer
- 7. Connectors
- 7.1. Accumulo Connector
- 7.2. Black Hole Connector
- 7.3. Cassandra Connector
- 7.4. Druid Connector
- 7.5. Elasticsearch Connector
- 7.6. Hive Connector
- 7.7. Hive Security Configuration
- 7.8. JMX Connector
- 7.9. Kafka Connector
- 7.10. Kafka Connector Tutorial
- 7.11. Kudu Connector
- 7.12. Local File Connector
- 7.13. Memory Connector
- 7.14. MongoDB Connector
- 7.15. MySQL Connector
- 7.16. Pinot Connector
- 7.17. PostgreSQL Connector
- 7.18. Redis Connector
- 7.19. Redshift Connector
- 7.20. SQL Server Connector
- 7.21. System Connector
- 7.22. Thrift Connector
- 7.23. TPCDS Connector
- 7.24. TPCH Connector
- 8. Functions and Operators
- 8.1. Logical Operators
- 8.2. Comparison Functions and Operators
- 8.3. Conditional Expressions
- 8.4. Lambda Expressions
- 8.5. Conversion Functions
- 8.6. Mathematical Functions and Operators
- 8.7. Bitwise Functions
- 8.8. Decimal Functions and Operators
- 8.9. String Functions and Operators
- 8.10. Regular Expression Functions
- 8.11. Binary Functions and Operators
- 8.12. JSON Functions and Operators
- 8.13. Date and Time Functions and Operators
- 8.14. Aggregate Functions
- 8.15. Window Functions
- 8.16. Array Functions and Operators
- 8.17. Map Functions and Operators
- 8.18. URL Functions
- 8.19. IP Functions
- 8.20. Geospatial Functions
- 8.21. HyperLogLog Functions
- 8.22. KHyperLogLog Functions
- 8.23. Quantile Digest Functions
- 8.24. Color Functions
- 8.25. Session Information
- 8.26. Teradata Functions
- 8.27. Internationalization Functions
- 9. SQL Language
- 10. SQL Statement Syntax
- 10.1. ALTER FUNCTION
- 10.2. ALTER SCHEMA
- 10.3. ALTER TABLE
- 10.4. ANALYZE
- 10.5. CALL
- 10.6. COMMIT
- 10.7. CREATE FUNCTION
- 10.8. CREATE ROLE
- 10.9. CREATE SCHEMA
- 10.10. CREATE TABLE
- 10.11. CREATE TABLE AS
- 10.12. CREATE VIEW
- 10.13. DEALLOCATE PREPARE
- 10.14. DELETE
- 10.15. DESCRIBE
- 10.16. DESCRIBE INPUT
- 10.17. DESCRIBE OUTPUT
- 10.18. DROP FUNCTION
- 10.19. DROP ROLE
- 10.20. DROP SCHEMA
- 10.21. DROP TABLE
- 10.22. DROP VIEW
- 10.23. EXECUTE
- 10.24. EXPLAIN
- 10.25. EXPLAIN ANALYZE
- 10.26. GRANT
- 10.27. GRANT ROLES
- 10.28. INSERT
- 10.29. PREPARE
- 10.30. RESET SESSION
- 10.31. REVOKE
- 10.32. REVOKE ROLES
- 10.33. ROLLBACK
- 10.34. SELECT
- 10.35. SET ROLE
- 10.36. SET SESSION
- 10.37. SHOW CATALOGS
- 10.38. SHOW COLUMNS
- 10.39. SHOW CREATE TABLE
- 10.40. SHOW CREATE VIEW
- 10.41. SHOW FUNCTIONS
- 10.42. SHOW GRANTS
- 10.43. SHOW ROLE GRANTS
- 10.44. SHOW ROLES
- 10.45. SHOW SCHEMAS
- 10.46. SHOW SESSION
- 10.47. SHOW STATS
- 10.48. SHOW TABLES
- 10.49. START TRANSACTION
- 10.50. USE
- 10.51. VALUES
- 11. Migration
- 12. Developer Guide
- 13. Release Notes
- 13.1. Release 0.237
- 13.2. Release 0.236
- 13.3. Release 0.235.1
- 13.4. Release 0.235
- 13.5. Release 0.234.3
- 13.6. Release 0.234.2
- 13.7. Release 0.234.1
- 13.8. Release 0.234
- 13.9. Release 0.233.1
- 13.10. Release 0.233
- 13.11. Release 0.232
- 13.12. Release 0.231
- 13.13. Release 0.230
- 13.14. Release 0.229
- 13.15. Release 0.228
- 13.16. Release 0.227
- 13.17. Release 0.226
- 13.18. Release 0.225
- 13.19. Release 0.224
- 13.20. Release 0.223
- 13.21. Release 0.222
- 13.22. Release 0.221
- 13.23. Release 0.220
- 13.24. Release 0.219
- 13.25. Release 0.218
- 13.26. Release 0.217
- 13.27. Release 0.216
- 13.28. Release 0.215
- 13.29. Release 0.214
- 13.30. Release 0.213
- 13.31. Release 0.212
- 13.32. Release 0.211
- 13.33. Release 0.210
- 13.34. Release 0.209
- 13.35. Release 0.208
- 13.36. Release 0.207
- 13.37. Release 0.206
- 13.38. Release 0.205
- 13.39. Release 0.204
- 13.40. Release 0.203
- 13.41. Release 0.202
- 13.42. Release 0.201
- 13.43. Release 0.200
- 13.44. Release 0.199
- 13.45. Release 0.198
- 13.46. Release 0.197
- 13.47. Release 0.196
- 13.48. Release 0.195
- 13.49. Release 0.194
- 13.50. Release 0.193
- 13.51. Release 0.192
- 13.52. Release 0.191
- 13.53. Release 0.190
- 13.54. Release 0.189
- 13.55. Release 0.188
- 13.56. Release 0.187
- 13.57. Release 0.186
- 13.58. Release 0.185
- 13.59. Release 0.184
- 13.60. Release 0.183
- 13.61. Release 0.182
- 13.62. Release 0.181
- 13.63. Release 0.180
- 13.64. Release 0.179
- 13.65. Release 0.178
- 13.66. Release 0.177
- 13.67. Release 0.176
- 13.68. Release 0.175
- 13.69. Release 0.174
- 13.70. Release 0.173
- 13.71. Release 0.172
- 13.72. Release 0.171
- 13.73. Release 0.170
- 13.74. Release 0.169
- 13.75. Release 0.168
- 13.76. Release 0.167
- 13.77. Release 0.166
- 13.78. Release 0.165
- 13.79. Release 0.164
- 13.80. Release 0.163
- 13.81. Release 0.162
- 13.82. Release 0.161
- 13.83. Release 0.160
- 13.84. Release 0.159
- 13.85. Release 0.158
- 13.86. Release 0.157.1
- 13.87. Release 0.157
- 13.88. Release 0.156
- 13.89. Release 0.155
- 13.90. Release 0.154
- 13.91. Release 0.153
- 13.92. Release 0.152.3
- 13.93. Release 0.152.2
- 13.94. Release 0.152.1
- 13.95. Release 0.152
- 13.96. Release 0.151
- 13.97. Release 0.150
- 13.98. Release 0.149
- 13.99. Release 0.148
- 13.100. Release 0.147
- 13.101. Release 0.146
- 13.102. Release 0.145
- 13.103. Release 0.144.7
- 13.104. Release 0.144.6
- 13.105. Release 0.144.5
- 13.106. Release 0.144.4
- 13.107. Release 0.144.3
- 13.108. Release 0.144.2
- 13.109. Release 0.144.1
- 13.110. Release 0.144
- 13.111. Release 0.143
- 13.112. Release 0.142
- 13.113. Release 0.141
- 13.114. Release 0.140
- 13.115. Release 0.139
- 13.116. Release 0.138
- 13.117. Release 0.137
- 13.118. Release 0.136
- 13.119. Release 0.135
- 13.120. Release 0.134
- 13.121. Release 0.133
- 13.122. Release 0.132
- 13.123. Release 0.131
- 13.124. Release 0.130
- 13.125. Release 0.129
- 13.126. Release 0.128
- 13.127. Release 0.127
- 13.128. Release 0.126
- 13.129. Release 0.125
- 13.130. Release 0.124
- 13.131. Release 0.123
- 13.132. Release 0.122
- 13.133. Release 0.121
- 13.134. Release 0.120
- 13.135. Release 0.119
- 13.136. Release 0.118
- 13.137. Release 0.117
- 13.138. Release 0.116
- 13.139. Release 0.115
- 13.140. Release 0.114
- 13.141. Release 0.113
- 13.142. Release 0.112
- 13.143. Release 0.111
- 13.144. Release 0.110
- 13.145. Release 0.109
- 13.146. Release 0.108
- 13.147. Release 0.107
- 13.148. Release 0.106
- 13.149. Release 0.105
- 13.150. Release 0.104
- 13.151. Release 0.103
- 13.152. Release 0.102
- 13.153. Release 0.101
- 13.154. Release 0.100
- 13.155. Release 0.99
- 13.156. Release 0.98
- 13.157. Release 0.97
- 13.158. Release 0.96
- 13.159. Release 0.95
- 13.160. Release 0.94
- 13.161. Release 0.93
- 13.162. Release 0.92
- 13.163. Release 0.91
- 13.164. Release 0.90
- 13.165. Release 0.89
- 13.166. Release 0.88
- 13.167. Release 0.87
- 13.168. Release 0.86
- 13.169. Release 0.85
- 13.170. Release 0.84
- 13.171. Release 0.83
- 13.172. Release 0.82
- 13.173. Release 0.81
- 13.174. Release 0.80
- 13.175. Release 0.79
- 13.176. Release 0.78
- 13.177. Release 0.77
- 13.178. Release 0.76
- 13.179. Release 0.75
- 13.180. Release 0.74
- 13.181. Release 0.73
- 13.182. Release 0.72
- 13.183. Release 0.71
- 13.184. Release 0.70
- 13.185. Release 0.69
- 13.186. Release 0.68
- 13.187. Release 0.67
- 13.188. Release 0.66
- 13.189. Release 0.65
- 13.190. Release 0.64
- 13.191. Release 0.63
- 13.192. Release 0.62
- 13.193. Release 0.61
- 13.194. Release 0.60
- 13.195. Release 0.59
- 13.196. Release 0.58
- 13.197. Release 0.57
- 13.198. Release 0.56
- 13.199. Release 0.55
- 13.200. Release 0.54