Presto Documentation
- 1. Overview
- 2. System Requirements
- 3. Getting Started
- 4. Presto Installation on a Sandbox VM
- 5. Presto Server Installation on a Cluster (Presto Admin and RPMs)
- 6. Presto Server Installation on an AWS EMR (Presto Admin and RPMs)
- 7. Presto Client Software
- 8. Presto Admin
- 9. Security
- 10. Administration
- 11. Teradata QueryGrid
- 12. Teradata Supported Connectors
- 12.1. Black Hole Connector
- 12.2. Cassandra Connector
- 12.3. Hive Connector
- 12.4. Hive Security Configuration
- 12.5. Memory Connector
- 12.6. JMX Connector
- 12.7. MySQL Connector
- 12.8. PostgreSQL Connector
- 12.9. SQL Server Connector
- 12.10. System Connector
- 12.11. Teradata Connector
- 12.12. TPCH Connector
- 12.13. TPCDS Connector
- 13. Community Supported Connectors
- 14. Community Supported Functionality
- 15. Functions and Operators
- 15.1. Logical Operators
- 15.2. Comparison Functions and Operators
- 15.3. Conditional Expressions
- 15.4. Conversion Functions
- 15.5. Mathematical Functions and Operators
- 15.6. Bitwise Functions
- 15.7. Decimal Functions and Operators
- 15.8. String Functions and Operators
- 15.9. Binary Functions
- 15.10. Date and Time Functions and Operators
- 15.11. Regular Expression Functions
- 15.12. JSON Functions
- 15.13. URL Functions
- 15.14. Aggregate Functions
- 15.15. Window Functions
- 15.16. Color Functions
- 15.17. Array Functions and Operators
- 15.18. Map Functions and Operators
- 15.19. Lambda Expressions and Functions
- 15.20. Teradata Functions
- 16. SQL Language
- 17. SQL Statement Syntax
- 17.1. ALTER SCHEMA
- 17.2. ALTER TABLE
- 17.3. CALL
- 17.4. COMMIT
- 17.5. CREATE ROLE
- 17.6. CREATE SCHEMA
- 17.7. CREATE TABLE
- 17.8. CREATE TABLE AS
- 17.9. CREATE VIEW
- 17.10. DEALLOCATE PREPARE
- 17.11. DELETE
- 17.12. DESCRIBE
- 17.13. DESCRIBE INPUT
- 17.14. DESCRIBE OUTPUT
- 17.15. DROP ROLE
- 17.16. DROP SCHEMA
- 17.17. DROP TABLE
- 17.18. DROP VIEW
- 17.19. EXECUTE
- 17.20. EXPLAIN
- 17.21. EXPLAIN ANALYZE
- 17.22. GRANT
- 17.23. GRANT ROLES
- 17.24. INSERT
- 17.25. PREPARE
- 17.26. RESET SESSION
- 17.27. REVOKE
- 17.28. REVOKE ROLES
- 17.29. ROLLBACK
- 17.30. SELECT
- 17.31. SET ROLE
- 17.32. SET SESSION
- 17.33. SHOW CATALOGS
- 17.34. SHOW COLUMNS
- 17.35. SHOW CREATE TABLE
- 17.36. SHOW CREATE VIEW
- 17.37. SHOW FUNCTIONS
- 17.38. SHOW GRANTS
- 17.39. SHOW PARTITIONS
- 17.40. SHOW ROLE GRANTS
- 17.41. SHOW ROLES
- 17.42. SHOW SCHEMAS
- 17.43. SHOW SESSION
- 17.44. SHOW TABLES
- 17.45. START TRANSACTION
- 17.46. USE
- 17.47. VALUES
- 18. Migration
- 19. Query Optimizer
- 20. Developer Guide
- 21. Older Versions
- 22. Release Notes
- 22.1. Release 0.167-t
- 22.2. Release 0.157.1-t
- 22.3. Release 0.157.1-t.0.1
- 22.4. Release 0.157.1-t.0.3
- 22.5. Release 0.157.1-t.0.4
- 22.6. Release 0.157.1-t.0.5
- 22.7. Release 0.157.1-t.0.6
- 22.8. Release 0.157.1-t.0.7
- 22.9. Release 0.157.1-t.0.8
- 22.10. Release 0.157.1-t.1
- 22.11. Release 0.152.1-t
- 22.12. Release 0.152.1-t.0.1
- 22.13. Release 0.152.1-t.0.2
- 22.14. Release 0.152.1-t.0.3
- 22.15. Release 0.152.1-t.0.4
- 22.16. Release 0.148-t.1.2
- 22.17. Release 0.141-t
- 22.18. Release 0.127-t
- 22.19. Release 0.167
- 22.20. Release 0.166
- 22.21. Release 0.165
- 22.22. Release 0.164
- 22.23. Release 0.163
- 22.24. Release 0.162
- 22.25. Release 0.161
- 22.26. Release 0.160
- 22.27. Release 0.159
- 22.28. Release 0.158
- 22.29. Release 0.157.1
- 22.30. Release 0.157
- 22.31. Release 0.156
- 22.32. Release 0.155
- 22.33. Release 0.154
- 22.34. Release 0.153
- 22.35. Release 0.152.3
- 22.36. Release 0.152.2
- 22.37. Release 0.152.1
- 22.38. Release 0.152
- 22.39. Release 0.151
- 22.40. Release 0.150
- 22.41. Release 0.149
- 22.42. Release 0.148
- 22.43. Release 0.147
- 22.44. Release 0.146
- 22.45. Release 0.145
- 22.46. Release 0.144.7
- 22.47. Release 0.144.6
- 22.48. Release 0.144.5
- 22.49. Release 0.144.4
- 22.50. Release 0.144.3
- 22.51. Release 0.144.2
- 22.52. Release 0.144.1
- 22.53. Release 0.144
- 22.54. Release 0.143
- 22.55. Release 0.142
- 22.56. Release 0.141
- 22.57. Release 0.140
- 22.58. Release 0.139
- 22.59. Release 0.138
- 22.60. Release 0.137
- 22.61. Release 0.136
- 22.62. Release 0.135
- 22.63. Release 0.134
- 22.64. Release 0.133
- 22.65. Release 0.132
- 22.66. Release 0.131
- 22.67. Release 0.130
- 22.68. Release 0.129
- 22.69. Release 0.128
- 22.70. Release 0.127
- 22.71. Release 0.126
- 22.72. Release 0.125
- 22.73. Release 0.124
- 22.74. Release 0.123
- 22.75. Release 0.122
- 22.76. Release 0.121
- 22.77. Release 0.120
- 22.78. Release 0.119
- 22.79. Release 0.118
- 22.80. Release 0.117
- 22.81. Release 0.116
- 22.82. Release 0.115
- 22.83. Release 0.114
- 22.84. Release 0.113
- 22.85. Release 0.112
- 22.86. Release 0.111
- 22.87. Release 0.110
- 22.88. Release 0.109
- 22.89. Release 0.108
- 22.90. Release 0.107
- 22.91. Release 0.106
- 22.92. Release 0.105
- 22.93. Release 0.104
- 22.94. Release 0.103
- 22.95. Release 0.102
- 22.96. Release 0.101
- 22.97. Release 0.100
- 22.98. Release 0.99
- 22.99. Release 0.98
- 22.100. Release 0.97
- 22.101. Release 0.96
- 22.102. Release 0.95
- 22.103. Release 0.94
- 22.104. Release 0.93
- 22.105. Release 0.92
- 22.106. Release 0.91
- 22.107. Release 0.90
- 22.108. Release 0.89
- 22.109. Release 0.88
- 22.110. Release 0.87
- 22.111. Release 0.86
- 22.112. Release 0.85
- 22.113. Release 0.84
- 22.114. Release 0.83
- 22.115. Release 0.82
- 22.116. Release 0.81
- 22.117. Release 0.80
- 22.118. Release 0.79
- 22.119. Release 0.78
- 22.120. Release 0.77
- 22.121. Release 0.76
- 22.122. Release 0.75
- 22.123. Release 0.74
- 22.124. Release 0.73
- 22.125. Release 0.72
- 22.126. Release 0.71
- 22.127. Release 0.70
- 22.128. Release 0.69
- 22.129. Release 0.68
- 22.130. Release 0.67
- 22.131. Release 0.66
- 22.132. Release 0.65
- 22.133. Release 0.64
- 22.134. Release 0.63
- 22.135. Release 0.62
- 22.136. Release 0.61
- 22.137. Release 0.60
- 22.138. Release 0.59
- 22.139. Release 0.58
- 22.140. Release 0.57
- 22.141. Release 0.56
- 22.142. Release 0.55
- 22.143. Release 0.54