Presto Documentation

• 1. Overview
  • 1.1. Teradata Distribution of Presto
  • 1.2. Use Cases
  • 1.3. What’s New in 0.179-t.0.1
• 2. System Requirements
  • 2.1. Hardware Requirements
  • 2.2. Software Requirements
• 3. Getting Started
  • 3.1. Presto Installation
  • 3.2. Presto Client Software Installation
• 4. Presto Installation on a Sandbox VM
  • 4.1. System Requirements
  • 4.2. Installing a Presto VM Sandbox for CDH
  • 4.3. Installing a Presto VM Sandbox for HDP
• 5. Presto Server Installation on a Cluster (Presto Admin and RPMs)
  • 5.1. Installation on a Cluster
• 6. Presto Server Installation on an AWS EMR (Presto Admin and RPMs)
  • 6.1. Installation on an AWS EMR
• 7. Presto Client Software
  • 7.1. Command Line Interface
  • 7.2. JDBC Driver
  • 7.3. ODBC Drivers
• 8. Presto Admin
  • 8.1. Presto Version Compatibility
  • 8.2. Quick Start Guide
  • 8.3. Setting up Presto Admin on an Amazon EMR cluster
  • 8.4. Advanced Installation Options
  • 8.5. Configuring the Presto Port
  • 8.6. SSH Configuration
  • 8.7. Presto-Admin Commands
  • 8.8. Presto-Admin Command-Line Options
• 9. Security
  • 9.1. Coordinator Kerberos Authentication
  • 9.2. CLI Kerberos Authentication
  • 9.3. LDAP Authentication
  • 9.4. Java Keystores and Truststores
  • 9.5. Built-in System Access Control
  • 9.6. Secure Internal Communication
• 10. Administration
  • 10.1. Web Interface
  • 10.2. Tuning Presto
  • 10.3. Properties Reference
  • 10.4. Queue Configuration
  • 10.5. Resource Group Configuration
  • 10.6. Query Performance Analysis
  • 10.7. Presto on AWS EMR
• 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
  • 13.1. Accumulo Connector
  • 13.2. Kafka Connector
  • 13.3. Kafka Connector Tutorial
  • 13.4. Local File Connector
  • 13.5. MongoDB Connector
  • 13.6. Redis Connector
• 14. Community Supported Functionality
  • 14.1. Manual Tarball Installation
  • 14.2. Other Installation Methods
  • 14.3. Presto Verifier
  • 14.4. Benchmark Driver
  • 14.5. Web Connector for Tableau
• 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 and Operators
  • 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
  • 16.1. Data Types
• 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
  • 18.1. Migrating From Hive
• 19. Query Optimizer
  • 19.1. Logical Planner
  • 19.2. Table Statistics
  • 19.3. Cost in EXPLAIN
  • 19.4. Join Reordering
• 20. Spilling to disk
  • 20.1. Overview
  • 20.2. Memory management and spill
  • 20.3. Spill disk space
  • 20.4. Supported operations
• 21. Developer Guide
  • 21.1. SPI Overview
  • 21.2. Connectors
  • 21.3. Example HTTP Connector
  • 21.4. Types
  • 21.5. Functions
  • 21.6. System Access Control
  • 21.7. Event Listener
• 22. Older Versions
• 23. Release Notes
  • 23.1. Release 0.179-t
  • 23.2. Release 0.167-t
  • 23.3. Release 0.167-t.0.4
  • 23.4. Release 0.167-t.0.5
  • 23.5. Release 0.167-t.0.6
  • 23.6. Release 0.157.1-t
  • 23.7. Release 0.157.1-t.0.1
  • 23.8. Release 0.157.1-t.0.3
  • 23.9. Release 0.157.1-t.0.4
  • 23.10. Release 0.157.1-t.0.5
  • 23.11. Release 0.157.1-t.0.6
  • 23.12. Release 0.157.1-t.0.7
  • 23.13. Release 0.157.1-t.0.8
  • 23.14. Release 0.157.1-t.1
  • 23.15. Release 0.152.1-t
  • 23.16. Release 0.152.1-t.0.1
  • 23.17. Release 0.152.1-t.0.2
  • 23.18. Release 0.152.1-t.0.3
  • 23.19. Release 0.152.1-t.0.4
  • 23.20. Release 0.148-t.1.2
  • 23.21. Release 0.141-t
  • 23.22. Release 0.127-t
  • 23.23. Release 0.179
  • 23.24. Release 0.178
  • 23.25. Release 0.177
  • 23.26. Release 0.176
  • 23.27. Release 0.175
  • 23.28. Release 0.174
  • 23.29. Release 0.173
  • 23.30. Release 0.172
  • 23.31. Release 0.171
  • 23.32. Release 0.170
  • 23.33. Release 0.169
  • 23.34. Release 0.168
  • 23.35. Release 0.167
  • 23.36. Release 0.166
  • 23.37. Release 0.165
  • 23.38. Release 0.164
  • 23.39. Release 0.163
  • 23.40. Release 0.162
  • 23.41. Release 0.161
  • 23.42. Release 0.160
  • 23.43. Release 0.159
  • 23.44. Release 0.158
  • 23.45. Release 0.157.1
  • 23.46. Release 0.157
  • 23.47. Release 0.156
  • 23.48. Release 0.155
  • 23.49. Release 0.154
  • 23.50. Release 0.153
  • 23.51. Release 0.152.3
  • 23.52. Release 0.152.2
  • 23.53. Release 0.152.1
  • 23.54. Release 0.152
  • 23.55. Release 0.151
  • 23.56. Release 0.150
  • 23.57. Release 0.149
  • 23.58. Release 0.148
  • 23.59. Release 0.147
  • 23.60. Release 0.146
  • 23.61. Release 0.145
  • 23.62. Release 0.144.7
  • 23.63. Release 0.144.6
  • 23.64. Release 0.144.5
  • 23.65. Release 0.144.4
  • 23.66. Release 0.144.3
  • 23.67. Release 0.144.2
  • 23.68. Release 0.144.1
  • 23.69. Release 0.144
  • 23.70. Release 0.143
  • 23.71. Release 0.142
  • 23.72. Release 0.141
  • 23.73. Release 0.140
  • 23.74. Release 0.139
  • 23.75. Release 0.138
  • 23.76. Release 0.137
  • 23.77. Release 0.136
  • 23.78. Release 0.135
  • 23.79. Release 0.134
  • 23.80. Release 0.133
  • 23.81. Release 0.132
  • 23.82. Release 0.131
  • 23.83. Release 0.130
  • 23.84. Release 0.129
  • 23.85. Release 0.128
  • 23.86. Release 0.127
  • 23.87. Release 0.126
  • 23.88. Release 0.125
  • 23.89. Release 0.124
  • 23.90. Release 0.123
  • 23.91. Release 0.122
  • 23.92. Release 0.121
  • 23.93. Release 0.120
  • 23.94. Release 0.119
  • 23.95. Release 0.118
  • 23.96. Release 0.117
  • 23.97. Release 0.116
  • 23.98. Release 0.115
  • 23.99. Release 0.114
  • 23.100. Release 0.113
  • 23.101. Release 0.112
  • 23.102. Release 0.111
  • 23.103. Release 0.110
  • 23.104. Release 0.109
  • 23.105. Release 0.108
  • 23.106. Release 0.107
  • 23.107. Release 0.106
  • 23.108. Release 0.105
  • 23.109. Release 0.104
  • 23.110. Release 0.103
  • 23.111. Release 0.102
  • 23.112. Release 0.101
  • 23.113. Release 0.100
  • 23.114. Release 0.99
  • 23.115. Release 0.98
  • 23.116. Release 0.97
  • 23.117. Release 0.96
  • 23.118. Release 0.95
  • 23.119. Release 0.94
  • 23.120. Release 0.93
  • 23.121. Release 0.92
  • 23.122. Release 0.91
  • 23.123. Release 0.90
  • 23.124. Release 0.89
  • 23.125. Release 0.88
  • 23.126. Release 0.87
  • 23.127. Release 0.86
  • 23.128. Release 0.85
  • 23.129. Release 0.84
  • 23.130. Release 0.83
  • 23.131. Release 0.82
  • 23.132. Release 0.81
  • 23.133. Release 0.80
  • 23.134. Release 0.79
  • 23.135. Release 0.78
  • 23.136. Release 0.77
  • 23.137. Release 0.76
  • 23.138. Release 0.75
  • 23.139. Release 0.74
  • 23.140. Release 0.73
  • 23.141. Release 0.72
  • 23.142. Release 0.71
  • 23.143. Release 0.70
  • 23.144. Release 0.69
  • 23.145. Release 0.68
  • 23.146. Release 0.67
  • 23.147. Release 0.66
  • 23.148. Release 0.65
  • 23.149. Release 0.64
  • 23.150. Release 0.63
  • 23.151. Release 0.62
  • 23.152. Release 0.61
  • 23.153. Release 0.60
  • 23.154. Release 0.59
  • 23.155. Release 0.58
  • 23.156. Release 0.57
  • 23.157. Release 0.56
  • 23.158. Release 0.55
  • 23.159. Release 0.54