Presto 0.220 Documentation
Presto 是 Facebook 开源的大数据查询引擎，可对250PB以上的数据进行快速地交互式分析，查询的速度达到商业数据仓库的级别。据称该引擎的性能是 Hive 的 10 倍以上。
数据库 150人已学习
目录
-
1. Overview
266 浏览
- 1.1. Use Cases 202 浏览
- 1.2. Presto Concepts 124 浏览
-
2. Installation
121 浏览
- 2.1. Deploying Presto 141 浏览
- 2.2. Command Line Interface 158 浏览
- 2.3. JDBC Driver 109 浏览
- 2.4. Presto Verifier 142 浏览
- 2.5. Benchmark Driver 92 浏览
- 2.6. Web Connector for Tableau 111 浏览
- 3. Security 108 浏览
-
4. Administration
129 浏览
- 4.1. Web Interface 127 浏览
- 4.2. Tuning Presto 145 浏览
- 4.3. Properties Reference 122 浏览
- 4.4. Spill to Disk 146 浏览
- 4.5. Resource Groups 123 浏览
- 4.6. Session Property Managers 137 浏览
- 4.7. Distributed sort 158 浏览
-
5. Connectors
120 浏览
- 5.1. Accumulo Connector 157 浏览
- 5.2. Black Hole Connector 105 浏览
- 5.3. Cassandra Connector 110 浏览
- 5.4. Elasticsearch Connector 131 浏览
- 5.5. Hive Connector 139 浏览
- 5.6. Hive Security Configuration 128 浏览
- 5.7. JMX Connector 156 浏览
- 5.8. Kafka Connector 114 浏览
- 5.9. Kafka Connector Tutorial 105 浏览
- 5.10. Kudu Connector 103 浏览
- 5.11. Local File Connector 93 浏览
- 5.12. Memory Connector 200 浏览
- 5.13. MongoDB Connector 116 浏览
- 5.14. MySQL Connector 110 浏览
- 5.15. PostgreSQL Connector 94 浏览
- 5.16. Redis Connector 149 浏览
- 5.17. Redshift Connector 93 浏览
- 5.18. SQL Server Connector 130 浏览
- 5.19. System Connector 171 浏览
- 5.20. Thrift Connector 102 浏览
- 5.21. TPCDS Connector 131 浏览
- 5.22. TPCH Connector 113 浏览
-
6. Functions and Operators
121 浏览
- 6.1. Logical Operators 115 浏览
- 6.2. Comparison Functions and Operators 97 浏览
- 6.3. Conditional Expressions 117 浏览
- 6.4. Lambda Expressions 110 浏览
- 6.5. Conversion Functions 118 浏览
- 6.6. Mathematical Functions and Operators 114 浏览
- 6.7. Bitwise Functions 83 浏览
- 6.8. Decimal Functions and Operators 166 浏览
- 6.9. String Functions and Operators 133 浏览
- 6.10. Regular Expression Functions 112 浏览
- 6.11. Binary Functions and Operators 114 浏览
- 6.12. JSON Functions and Operators 97 浏览
- 6.13. Date and Time Functions and Operators 194 浏览
- 6.14. Aggregate Functions 117 浏览
- 6.15. Window Functions 110 浏览
- 6.16. Array Functions and Operators 123 浏览
- 6.17. Map Functions and Operators 129 浏览
- 6.18. URL Functions 140 浏览
- 6.19. Geospatial Functions 115 浏览
- 6.20. HyperLogLog Functions 119 浏览
- 6.21. Quantile Digest Functions 114 浏览
- 6.22. Color Functions 112 浏览
- 6.23. Session Information 105 浏览
- 6.24. Teradata Functions 141 浏览
-
7. SQL Language
108 浏览
- 7.1. Data Types 158 浏览
- 7.2. Reserved Keywords 210 浏览
-
8. SQL Statement Syntax
130 浏览
- 8.1. ALTER SCHEMA 177 浏览
- 8.2. ALTER TABLE 156 浏览
- 8.3. ANALYZE 121 浏览
- 8.4. CALL 77 浏览
- 8.5. COMMIT 104 浏览
- 8.6. CREATE ROLE 128 浏览
- 8.7. CREATE SCHEMA 92 浏览
- 8.8. CREATE TABLE 101 浏览
- 8.9. CREATE TABLE AS 91 浏览
- 8.10. CREATE VIEW 122 浏览
- 8.11. DEALLOCATE PREPARE 106 浏览
- 8.12. DELETE 112 浏览
- 8.13. DESCRIBE 89 浏览
- 8.14. DESCRIBE INPUT 104 浏览
- 8.15. DESCRIBE OUTPUT 119 浏览
- 8.16. DROP ROLE 96 浏览
- 8.17. DROP SCHEMA 105 浏览
- 8.18. DROP TABLE 122 浏览
- 8.19. DROP VIEW 98 浏览
- 8.20. EXECUTE 112 浏览
- 8.21. EXPLAIN 91 浏览
- 8.22. EXPLAIN ANALYZE 90 浏览
- 8.23. GRANT 97 浏览
- 8.24. GRANT ROLES 107 浏览
- 8.25. INSERT 122 浏览
- 8.26. PREPARE 118 浏览
- 8.27. RESET SESSION 102 浏览
- 8.28. REVOKE 80 浏览
- 8.29. REVOKE ROLES 102 浏览
- 8.30. ROLLBACK 92 浏览
- 8.31. SELECT 146 浏览
- 8.32. SET ROLE 109 浏览
- 8.33. SET SESSION 107 浏览
- 8.34. SHOW CATALOGS 103 浏览
- 8.35. SHOW COLUMNS 85 浏览
- 8.36. SHOW CREATE TABLE 147 浏览
- 8.37. SHOW CREATE VIEW 94 浏览
- 8.38. SHOW FUNCTIONS 150 浏览
- 8.39. SHOW GRANTS 100 浏览
- 8.40. SHOW ROLE GRANTS 112 浏览
- 8.41. SHOW ROLES 97 浏览
- 8.42. SHOW SCHEMAS 108 浏览
- 8.43. SHOW SESSION 122 浏览
- 8.44. SHOW STATS 136 浏览
- 8.45. SHOW TABLES 110 浏览
- 8.46. START TRANSACTION 131 浏览
- 8.47. USE 92 浏览
- 8.48. VALUES 91 浏览
-
9. Migration
101 浏览
- 9.1. Migrating From Hive 123 浏览
-
10. Developer Guide
109 浏览
- 10.1. SPI Overview 88 浏览
- 10.2. Connectors 90 浏览
- 10.3. Example HTTP Connector 111 浏览
- 10.4. Types 102 浏览
- 10.5. Functions 81 浏览
- 10.6. System Access Control 163 浏览
- 10.7. Password Authenticator 89 浏览
- 10.8. Event Listener 109 浏览
- 11. Release Notes 182 浏览
