Presto Documentation
- 1. Overview
- 2. System Requirements
- 3. Getting Started
- 4. Presto Installation on a Sandbox VM
- 5. Presto Server Installation on a Cluster (Ambari)
- 6. Presto Server Installation on a Cluster (Presto Admin and RPMs)
- 7. Presto Server Installation on an AWS EMR (Presto Admin and RPMs)
- 8. Presto Client Software
- 9. Presto Admin
- 10. YARN Integration
- 10.1. Automated Installation on a YARN-Based Cluster
- 10.2. Manual Installation on a YARN-Based Cluster
- 10.3. Presto Installation Directory Structure on YARN-Based Clusters
- 10.4. Presto Configuration Options for YARN-Based Clusters
- 10.5. Advanced Configuration Options for YARN-Based Clusters
- 10.6. Debugging and Logging for a YARN-Based Cluster
- 11. Administration
- 12. Connectors
- 13. Security
- 14. Functions and Operators
- 14.1. Logical Operators
- 14.2. Comparison Functions and Operators
- 14.3. Conditional Expressions
- 14.4. Conversion Functions
- 14.5. Mathematical Functions and Operators
- 14.6. Bitwise Functions
- 14.7. Decimal Functions and Operators
- 14.8. String Functions and Operators
- 14.9. Binary Functions
- 14.10. Date and Time Functions and Operators
- 14.11. Regular Expression Functions
- 14.12. JSON Functions
- 14.13. URL Functions
- 14.14. Aggregate Functions
- 14.15. Window Functions
- 14.16. Color Functions
- 14.17. Array Functions and Operators
- 14.18. Map Functions and Operators
- 14.19. Teradata Functions
- 15. SQL Language
- 16. SQL Statement Syntax
- 16.1. ALTER TABLE
- 16.2. CALL
- 16.3. COMMIT
- 16.4. CREATE TABLE
- 16.5. CREATE TABLE AS
- 16.6. CREATE VIEW
- 16.7. DEALLOCATE PREPARE
- 16.8. DELETE
- 16.9. DESCRIBE
- 16.10. DESCRIBE INPUT
- 16.11. DESCRIBE OUTPUT
- 16.12. DROP TABLE
- 16.13. DROP VIEW
- 16.14. EXECUTE
- 16.15. EXPLAIN
- 16.16. EXPLAIN ANALYZE
- 16.17. GRANT
- 16.18. INSERT
- 16.19. PREPARE
- 16.20. RESET SESSION
- 16.21. REVOKE
- 16.22. ROLLBACK
- 16.23. SELECT
- 16.24. SET SESSION
- 16.25. SHOW CATALOGS
- 16.26. SHOW COLUMNS
- 16.27. SHOW CREATE TABLE
- 16.28. SHOW CREATE VIEW
- 16.29. SHOW FUNCTIONS
- 16.30. SHOW PARTITIONS
- 16.31. SHOW SCHEMAS
- 16.32. SHOW SESSION
- 16.33. SHOW TABLES
- 16.34. START TRANSACTION
- 16.35. USE
- 16.36. VALUES
- 17. Migration
- 18. Release Notes
- 18.1. Teradata Additions
- 18.2. Discontinue to support
- 18.3. Unsupported Features and Known Limitations
- 18.4. Release 0.148
- 18.5. Release 0.147
- 18.6. Release 0.146
- 18.7. Release 0.145
- 18.8. Release 0.144.5
- 18.9. Release 0.144.4
- 18.10. Release 0.144.3
- 18.11. Release 0.144.2
- 18.12. Release 0.144.1
- 18.13. Release 0.144
- 18.14. Release 0.143
- 18.15. Release 0.142
- 18.16. Release 0.141
- 18.17. Release 0.140
- 18.18. Release 0.139
- 18.19. Release 0.138
- 18.20. Release 0.137
- 18.21. Release 0.136
- 18.22. Release 0.135
- 18.23. Release 0.134
- 18.24. Release 0.133
- 18.25. Release 0.132
- 18.26. Release 0.131
- 18.27. Release 0.130
- 18.28. Release 0.129
- 18.29. Release 0.128
- 18.30. Release 0.127
- 18.31. Release 0.126
- 18.32. Release 0.125
- 18.33. Release 0.124
- 18.34. Release 0.123
- 18.35. Release 0.122
- 18.36. Release 0.121
- 18.37. Release 0.120
- 18.38. Release 0.119
- 18.39. Release 0.118
- 18.40. Release 0.117
- 18.41. Release 0.116
- 18.42. Release 0.115
- 18.43. Release 0.114
- 18.44. Release 0.113
- 18.45. Release 0.112
- 18.46. Release 0.111
- 18.47. Release 0.110
- 18.48. Release 0.109
- 18.49. Release 0.108
- 18.50. Release 0.107
- 18.51. Release 0.106
- 18.52. Release 0.105
- 18.53. Release 0.104
- 18.54. Release 0.103
- 18.55. Release 0.102
- 18.56. Release 0.101
- 18.57. Release 0.100
- 18.58. Release 0.99
- 18.59. Release 0.98
- 18.60. Release 0.97
- 18.61. Release 0.96
- 18.62. Release 0.95
- 18.63. Release 0.94
- 18.64. Release 0.93
- 18.65. Release 0.92
- 18.66. Release 0.91
- 18.67. Release 0.90
- 18.68. Release 0.89
- 18.69. Release 0.88
- 18.70. Release 0.87
- 18.71. Release 0.86
- 18.72. Release 0.85
- 18.73. Release 0.84
- 18.74. Release 0.83
- 18.75. Release 0.82
- 18.76. Release 0.81
- 18.77. Release 0.80
- 18.78. Release 0.79
- 18.79. Release 0.78
- 18.80. Release 0.77
- 18.81. Release 0.76
- 18.82. Release 0.75
- 18.83. Release 0.74
- 18.84. Release 0.73
- 18.85. Release 0.72
- 18.86. Release 0.71
- 18.87. Release 0.70
- 18.88. Release 0.69
- 18.89. Release 0.68
- 18.90. Release 0.67
- 18.91. Release 0.66
- 18.92. Release 0.65
- 18.93. Release 0.64
- 18.94. Release 0.63
- 18.95. Release 0.62
- 18.96. Release 0.61
- 18.97. Release 0.60
- 18.98. Release 0.59
- 18.99. Release 0.58
- 18.100. Release 0.57
- 18.101. Release 0.56
- 18.102. Release 0.55
- 18.103. Release 0.54