Presto Documentation
- 1. Overview
- 2. Installation
- 3. Security
- 4. Administration
- 5. Connectors
- 5.1. Accumulo Connector
- 5.2. Black Hole Connector
- 5.3. Cassandra Connector
- 5.4. Hive Connector
- 5.5. Hive Security Configuration
- 5.6. JMX Connector
- 5.7. Kafka Connector
- 5.8. Kafka Connector Tutorial
- 5.9. Kudu Connector
- 5.10. Local File Connector
- 5.11. Memory Connector
- 5.12. MongoDB Connector
- 5.13. MySQL Connector
- 5.14. PostgreSQL Connector
- 5.15. Redis Connector
- 5.16. Redshift Connector
- 5.17. SQL Server Connector
- 5.18. System Connector
- 5.19. Thrift Connector
- 5.20. TPCDS Connector
- 5.21. TPCH Connector
- 6. Functions and Operators
- 6.1. Logical Operators
- 6.2. Comparison Functions and Operators
- 6.3. Conditional Expressions
- 6.4. Lambda Expressions
- 6.5. Conversion Functions
- 6.6. Mathematical Functions and Operators
- 6.7. Bitwise Functions
- 6.8. Decimal Functions and Operators
- 6.9. String Functions and Operators
- 6.10. Regular Expression Functions
- 6.11. Binary Functions and Operators
- 6.12. JSON Functions and Operators
- 6.13. Date and Time Functions and Operators
- 6.14. Aggregate Functions
- 6.15. Window Functions
- 6.16. Array Functions and Operators
- 6.17. Map Functions and Operators
- 6.18. URL Functions
- 6.19. Geospatial Functions
- 6.20. HyperLogLog Functions
- 6.21. Color Functions
- 6.22. Session Information
- 6.23. Teradata Functions
- 7. SQL Language
- 8. SQL Statement Syntax
- 8.1. ALTER SCHEMA
- 8.2. ALTER TABLE
- 8.3. CALL
- 8.4. COMMIT
- 8.5. CREATE SCHEMA
- 8.6. CREATE TABLE
- 8.7. CREATE TABLE AS
- 8.8. CREATE VIEW
- 8.9. DEALLOCATE PREPARE
- 8.10. DELETE
- 8.11. DESCRIBE
- 8.12. DESCRIBE INPUT
- 8.13. DESCRIBE OUTPUT
- 8.14. DROP SCHEMA
- 8.15. DROP TABLE
- 8.16. DROP VIEW
- 8.17. EXECUTE
- 8.18. EXPLAIN
- 8.19. EXPLAIN ANALYZE
- 8.20. GRANT
- 8.21. INSERT
- 8.22. PREPARE
- 8.23. RESET SESSION
- 8.24. REVOKE
- 8.25. ROLLBACK
- 8.26. SELECT
- 8.27. SET SESSION
- 8.28. SHOW CATALOGS
- 8.29. SHOW COLUMNS
- 8.30. SHOW CREATE TABLE
- 8.31. SHOW CREATE VIEW
- 8.32. SHOW FUNCTIONS
- 8.33. SHOW GRANTS
- 8.34. SHOW SCHEMAS
- 8.35. SHOW SESSION
- 8.36. SHOW STATS
- 8.37. SHOW TABLES
- 8.38. START TRANSACTION
- 8.39. USE
- 8.40. VALUES
- 9. Migration
- 10. Developer Guide
- 11. Release Notes
- 11.1. Release 0.213
- 11.2. Release 0.212
- 11.3. Release 0.211
- 11.4. Release 0.210
- 11.5. Release 0.209
- 11.6. Release 0.208
- 11.7. Release 0.207
- 11.8. Release 0.206
- 11.9. Release 0.205
- 11.10. Release 0.204
- 11.11. Release 0.203
- 11.12. Release 0.202
- 11.13. Release 0.201
- 11.14. Release 0.200
- 11.15. Release 0.199
- 11.16. Release 0.198
- 11.17. Release 0.197
- 11.18. Release 0.196
- 11.19. Release 0.195
- 11.20. Release 0.194
- 11.21. Release 0.193
- 11.22. Release 0.192
- 11.23. Release 0.191
- 11.24. Release 0.190
- 11.25. Release 0.189
- 11.26. Release 0.188
- 11.27. Release 0.187
- 11.28. Release 0.186
- 11.29. Release 0.185
- 11.30. Release 0.184
- 11.31. Release 0.183
- 11.32. Release 0.182
- 11.33. Release 0.181
- 11.34. Release 0.180
- 11.35. Release 0.179
- 11.36. Release 0.178
- 11.37. Release 0.177
- 11.38. Release 0.176
- 11.39. Release 0.175
- 11.40. Release 0.174
- 11.41. Release 0.173
- 11.42. Release 0.172
- 11.43. Release 0.171
- 11.44. Release 0.170
- 11.45. Release 0.169
- 11.46. Release 0.168
- 11.47. Release 0.167
- 11.48. Release 0.166
- 11.49. Release 0.165
- 11.50. Release 0.164
- 11.51. Release 0.163
- 11.52. Release 0.162
- 11.53. Release 0.161
- 11.54. Release 0.160
- 11.55. Release 0.159
- 11.56. Release 0.158
- 11.57. Release 0.157.1
- 11.58. Release 0.157
- 11.59. Release 0.156
- 11.60. Release 0.155
- 11.61. Release 0.154
- 11.62. Release 0.153
- 11.63. Release 0.152.3
- 11.64. Release 0.152.2
- 11.65. Release 0.152.1
- 11.66. Release 0.152
- 11.67. Release 0.151
- 11.68. Release 0.150
- 11.69. Release 0.149
- 11.70. Release 0.148
- 11.71. Release 0.147
- 11.72. Release 0.146
- 11.73. Release 0.145
- 11.74. Release 0.144.7
- 11.75. Release 0.144.6
- 11.76. Release 0.144.5
- 11.77. Release 0.144.4
- 11.78. Release 0.144.3
- 11.79. Release 0.144.2
- 11.80. Release 0.144.1
- 11.81. Release 0.144
- 11.82. Release 0.143
- 11.83. Release 0.142
- 11.84. Release 0.141
- 11.85. Release 0.140
- 11.86. Release 0.139
- 11.87. Release 0.138
- 11.88. Release 0.137
- 11.89. Release 0.136
- 11.90. Release 0.135
- 11.91. Release 0.134
- 11.92. Release 0.133
- 11.93. Release 0.132
- 11.94. Release 0.131
- 11.95. Release 0.130
- 11.96. Release 0.129
- 11.97. Release 0.128
- 11.98. Release 0.127
- 11.99. Release 0.126
- 11.100. Release 0.125
- 11.101. Release 0.124
- 11.102. Release 0.123
- 11.103. Release 0.122
- 11.104. Release 0.121
- 11.105. Release 0.120
- 11.106. Release 0.119
- 11.107. Release 0.118
- 11.108. Release 0.117
- 11.109. Release 0.116
- 11.110. Release 0.115
- 11.111. Release 0.114
- 11.112. Release 0.113
- 11.113. Release 0.112
- 11.114. Release 0.111
- 11.115. Release 0.110
- 11.116. Release 0.109
- 11.117. Release 0.108
- 11.118. Release 0.107
- 11.119. Release 0.106
- 11.120. Release 0.105
- 11.121. Release 0.104
- 11.122. Release 0.103
- 11.123. Release 0.102
- 11.124. Release 0.101
- 11.125. Release 0.100
- 11.126. Release 0.99
- 11.127. Release 0.98
- 11.128. Release 0.97
- 11.129. Release 0.96
- 11.130. Release 0.95
- 11.131. Release 0.94
- 11.132. Release 0.93
- 11.133. Release 0.92
- 11.134. Release 0.91
- 11.135. Release 0.90
- 11.136. Release 0.89
- 11.137. Release 0.88
- 11.138. Release 0.87
- 11.139. Release 0.86
- 11.140. Release 0.85
- 11.141. Release 0.84
- 11.142. Release 0.83
- 11.143. Release 0.82
- 11.144. Release 0.81
- 11.145. Release 0.80
- 11.146. Release 0.79
- 11.147. Release 0.78
- 11.148. Release 0.77
- 11.149. Release 0.76
- 11.150. Release 0.75
- 11.151. Release 0.74
- 11.152. Release 0.73
- 11.153. Release 0.72
- 11.154. Release 0.71
- 11.155. Release 0.70
- 11.156. Release 0.69
- 11.157. Release 0.68
- 11.158. Release 0.67
- 11.159. Release 0.66
- 11.160. Release 0.65
- 11.161. Release 0.64
- 11.162. Release 0.63
- 11.163. Release 0.62
- 11.164. Release 0.61
- 11.165. Release 0.60
- 11.166. Release 0.59
- 11.167. Release 0.58
- 11.168. Release 0.57
- 11.169. Release 0.56
- 11.170. Release 0.55
- 11.171. Release 0.54