Presto Documentation

• 1. Overview
  • 1.1. Teradata Distribution of Presto
  • 1.2. Use Cases
• 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. System Requirements
  • 5.2. Installation on a Cluster
• 6. Presto Server Installation on an AWS EMR (Presto Admin and RPMs)
  • 6.1. System Requirements
  • 6.2. Installation on an AWS EMR
• 7. Alternative Installation Methods
  • Manual Tarball
  • Automated using Apache Ambari
  • Integration with Apache YARN
• 8. Presto Client Software
  • 8.1. Command Line Interface
  • 8.2. JDBC Driver
  • 8.3. ODBC Drivers
• 9. Presto Admin
  • 9.1. Quick Start Guide
  • 9.2. Setting up Presto Admin on an Amazon EMR cluster
  • 9.3. Advanced Installation Options
  • 9.4. Configuring the Presto Port
  • 9.5. SSH Configuration
  • 9.6. Presto-Admin Commands
  • 9.7. Presto-Admin Command-Line Options
• 10. Security
  • 10.1. Coordinator Kerberos Authentication
  • 10.2. CLI Kerberos Authentication
  • 10.3. LDAP Authentication
  • 10.4. Java Keystores and Truststores
  • 10.5. Secure Internal Communication
• 11. Administration
  • 11.1. Web Interface
  • 11.2. Tuning Presto
  • 11.3. Presto properties
  • 11.4. Queue Configuration
  • 11.5. Resource Group Configuration
  • 11.6. Feature Toggles
  • 11.7. Query Performance Analysis
  • 11.8. Presto on AWS EMR
• 12. Teradata QueryGrid
• 13. Teradata Supported Connectors
  • 13.1. Teradata Connector
  • 13.2. Hive Connector
  • 13.3. Hive Security Configuration
  • 13.4. Cassandra Connector
  • 13.5. MySQL Connector
  • 13.6. PostgreSQL Connector
  • 13.7. TPCH Connector
  • 13.8. TPCDS Connector
  • 13.9. System Connector
  • 13.10. Memory Connector
  • 13.11. JMX Connector
  • 13.12. Black Hole Connector
• 14. Community Supported Connectors
  • 14.1. Accumulo Connector
  • 14.2. Kafka Connector
  • 14.3. Kafka Connector Tutorial
  • 14.4. Local File Connector
  • 14.5. MongoDB Connector
  • 14.6. Redis Connector
• 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. 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 SCHEMA
  • 17.6. CREATE TABLE
  • 17.7. CREATE TABLE AS
  • 17.8. CREATE VIEW
  • 17.9. DEALLOCATE PREPARE
  • 17.10. DELETE
  • 17.11. DESCRIBE
  • 17.12. DESCRIBE INPUT
  • 17.13. DESCRIBE OUTPUT
  • 17.14. DROP SCHEMA
  • 17.15. DROP TABLE
  • 17.16. DROP VIEW
  • 17.17. EXECUTE
  • 17.18. EXPLAIN
  • 17.19. EXPLAIN ANALYZE
  • 17.20. GRANT
  • 17.21. INSERT
  • 17.22. PREPARE
  • 17.23. RESET SESSION
  • 17.24. REVOKE
  • 17.25. ROLLBACK
  • 17.26. SELECT
  • 17.27. SET SESSION
  • 17.28. SHOW CATALOGS
  • 17.29. SHOW COLUMNS
  • 17.30. SHOW CREATE TABLE
  • 17.31. SHOW CREATE VIEW
  • 17.32. SHOW FUNCTIONS
  • 17.33. SHOW GRANTS
  • 17.34. SHOW PARTITIONS
  • 17.35. SHOW SCHEMAS
  • 17.36. SHOW SESSION
  • 17.37. SHOW TABLES
  • 17.38. START TRANSACTION
  • 17.39. USE
  • 17.40. 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. Repartitioned and Replicated Joins
  • 19.5. Join Reordering
• 20. Developer Guide
  • 20.1. SPI Overview
  • 20.2. Connectors
  • 20.3. Example HTTP Connector
  • 20.4. Types
  • 20.5. Functions
  • 20.6. System Access Control
  • 20.7. Event Listener
• 21. Older Versions
• 22. Release Notes
  • 22.1. Release 0.157.1-t
  • 22.2. Release 0.157.1-t.0.1
  • 22.3. Release 0.157.1-t.0.3
  • 22.4. Release 0.157.1-t.0.4
  • 22.5. Release 0.157.1-t.0.5
  • 22.6. Release 0.157.1-t.0.6
  • 22.7. Release 0.157.1-t.0.7
  • 22.8. Release 0.157.1-t.0.8
  • 22.9. Release 0.152.1-t
  • 22.10. Release 0.152.1-t.0.1
  • 22.11. Release 0.152.1-t.0.2
  • 22.12. Release 0.152.1-t.0.3
  • 22.13. Release 0.152.1-t.0.4
  • 22.14. Release 0.148-t.1.2
  • 22.15. Release 0.141-t
  • 22.16. Release 0.127-t
  • 22.17. Release 0.157.1
  • 22.18. Release 0.157
  • 22.19. Release 0.156
  • 22.20. Release 0.155
  • 22.21. Release 0.154
  • 22.22. Release 0.153
  • 22.23. Release 0.152.3
  • 22.24. Release 0.152.2
  • 22.25. Release 0.152.1
  • 22.26. Release 0.152
  • 22.27. Release 0.151
  • 22.28. Release 0.150
  • 22.29. Release 0.149
  • 22.30. Release 0.148
  • 22.31. Release 0.147
  • 22.32. Release 0.146
  • 22.33. Release 0.145
  • 22.34. Release 0.144.7
  • 22.35. Release 0.144.6
  • 22.36. Release 0.144.5
  • 22.37. Release 0.144.4
  • 22.38. Release 0.144.3
  • 22.39. Release 0.144.2
  • 22.40. Release 0.144.1
  • 22.41. Release 0.144
  • 22.42. Release 0.143
  • 22.43. Release 0.142
  • 22.44. Release 0.141
  • 22.45. Release 0.140
  • 22.46. Release 0.139
  • 22.47. Release 0.138
  • 22.48. Release 0.137
  • 22.49. Release 0.136
  • 22.50. Release 0.135
  • 22.51. Release 0.134
  • 22.52. Release 0.133
  • 22.53. Release 0.132
  • 22.54. Release 0.131
  • 22.55. Release 0.130
  • 22.56. Release 0.129
  • 22.57. Release 0.128
  • 22.58. Release 0.127
  • 22.59. Release 0.126
  • 22.60. Release 0.125
  • 22.61. Release 0.124
  • 22.62. Release 0.123
  • 22.63. Release 0.122
  • 22.64. Release 0.121
  • 22.65. Release 0.120
  • 22.66. Release 0.119
  • 22.67. Release 0.118
  • 22.68. Release 0.117
  • 22.69. Release 0.116
  • 22.70. Release 0.115
  • 22.71. Release 0.114
  • 22.72. Release 0.113
  • 22.73. Release 0.112
  • 22.74. Release 0.111
  • 22.75. Release 0.110
  • 22.76. Release 0.109
  • 22.77. Release 0.108
  • 22.78. Release 0.107
  • 22.79. Release 0.106
  • 22.80. Release 0.105
  • 22.81. Release 0.104
  • 22.82. Release 0.103
  • 22.83. Release 0.102
  • 22.84. Release 0.101
  • 22.85. Release 0.100
  • 22.86. Release 0.99
  • 22.87. Release 0.98
  • 22.88. Release 0.97
  • 22.89. Release 0.96
  • 22.90. Release 0.95
  • 22.91. Release 0.94
  • 22.92. Release 0.93
  • 22.93. Release 0.92
  • 22.94. Release 0.91
  • 22.95. Release 0.90
  • 22.96. Release 0.89
  • 22.97. Release 0.88
  • 22.98. Release 0.87
  • 22.99. Release 0.86
  • 22.100. Release 0.85
  • 22.101. Release 0.84
  • 22.102. Release 0.83
  • 22.103. Release 0.82
  • 22.104. Release 0.81
  • 22.105. Release 0.80
  • 22.106. Release 0.79
  • 22.107. Release 0.78
  • 22.108. Release 0.77
  • 22.109. Release 0.76
  • 22.110. Release 0.75
  • 22.111. Release 0.74
  • 22.112. Release 0.73
  • 22.113. Release 0.72
  • 22.114. Release 0.71
  • 22.115. Release 0.70
  • 22.116. Release 0.69
  • 22.117. Release 0.68
  • 22.118. Release 0.67
  • 22.119. Release 0.66
  • 22.120. Release 0.65
  • 22.121. Release 0.64
  • 22.122. Release 0.63
  • 22.123. Release 0.62
  • 22.124. Release 0.61
  • 22.125. Release 0.60
  • 22.126. Release 0.59
  • 22.127. Release 0.58
  • 22.128. Release 0.57
  • 22.129. Release 0.56
  • 22.130. Release 0.55
  • 22.131. Release 0.54