×
思维导图备注
Presto 0.245.1 Documentation
首页
小程序
下载
阅读记录
书签管理
我的书签
添加书签
移除书签
编辑文档
9. SQL Language
来源 1
浏览
549
扫码
分享
2021-01-27 21:39:27
9. SQL Language
上一篇:
下一篇:
3. Security
3.4. Java Keystores and Truststores
3.1. Coordinator Kerberos Authentication
3.3. LDAP Authentication
3.5. Built-in System Access Control
3.7. Authorization
3.6. Secure Internal Communication
3.2. CLI Kerberos Authentication
2. Installation
2.3. JDBC Driver
2.1. Deploying Presto
2.6. Executing Presto on Spark
2.2. Command Line Interface
2.5. Web Connector for Tableau
2.4. Benchmark Driver
4. Administration
4.9. Distributed sort
4.7. Session Property Managers
4.2. Tuning Presto
4.3. Properties Reference
4.6. Resource Groups
4.4. Spill to Disk
4.1. Web Interface
4.5. Exchange Materialization
4.8. Function Namespace Managers
4.10. Presto Verifier
5. Cache
5.1. Alluxio Cache Service
6. Query Optimizer
6.3. Cost based optimizations
6.2. Cost in EXPLAIN
6.1. Table Statistics
11. Migration
11.1. Migrating From Hive
13. Release Notes
13.200. Release 0.73
13.219. Release 0.54
13.131. Release 0.142
13.60. Release 0.202
13.49. Release 0.213
13.110. Release 0.153
13.208. Release 0.65
13.151. Release 0.122
13.195. Release 0.78
13.2. Release 0.245
13.54. Release 0.208
13.37. Release 0.225
13.144. Release 0.129
13.150. Release 0.123
13.213. Release 0.60
13.44. Release 0.218
13.75. Release 0.187
13.58. Release 0.204
13.205. Release 0.68
13.57. Release 0.205
13.87. Release 0.175
13.203. Release 0.70
13.158. Release 0.115
13.91. Release 0.171
13.68. Release 0.194
13.113. Release 0.152.1
13.101. Release 0.161
13.24. Release 0.234.3
13.76. Release 0.186
13.112. Release 0.152.2
13.43. Release 0.219
13.23. Release 0.235
13.165. Release 0.108
13.30. Release 0.232
13.108. Release 0.155
13.207. Release 0.66
13.77. Release 0.185
13.160. Release 0.113
13.141. Release 0.132
13.211. Release 0.62
13.117. Release 0.149
13.136. Release 0.137
13.168. Release 0.105
13.20. Release 0.237
13.98. Release 0.164
13.198. Release 0.75
13.142. Release 0.131
13.103. Release 0.159
13.154. Release 0.119
13.52. Release 0.210
13.167. Release 0.106
13.176. Release 0.97
13.138. Release 0.135
13.212. Release 0.61
13.97. Release 0.165
13.189. Release 0.84
13.11. Release 0.242
13.3. Release 0.244.1
13.152. Release 0.121
13.178. Release 0.95
13.201. Release 0.72
13.9. Release 0.243
13.193. Release 0.80
13.159. Release 0.114
13.17. Release 0.238.3
13.202. Release 0.71
13.161. Release 0.112
13.65. Release 0.197
13.153. Release 0.120
13.196. Release 0.77
13.147. Release 0.126
13.84. Release 0.178
13.121. Release 0.145
13.127. Release 0.144.2
13.4. Release 0.244
13.125. Release 0.144.4
13.164. Release 0.109
13.16. Release 0.239
13.85. Release 0.177
13.28. Release 0.233.1
13.188. Release 0.85
13.29. Release 0.233
13.132. Release 0.141
13.163. Release 0.110
13.35. Release 0.227
13.72. Release 0.190
13.186. Release 0.87
13.183. Release 0.90
13.116. Release 0.150
13.26. Release 0.234.1
13.27. Release 0.234
13.32. Release 0.230
13.149. Release 0.124
13.33. Release 0.229
13.216. Release 0.57
13.187. Release 0.86
13.191. Release 0.82
13.92. Release 0.170
13.50. Release 0.212
13.215. Release 0.58
13.78. Release 0.184
13.14. Release 0.239.2
13.88. Release 0.174
13.118. Release 0.148
13.169. Release 0.104
13.181. Release 0.92
13.133. Release 0.140
13.140. Release 0.133
13.179. Release 0.94
13.38. Release 0.224
13.143. Release 0.130
13.46. Release 0.216
13.51. Release 0.211
13.48. Release 0.214
13.184. Release 0.89
13.105. Release 0.157.1
13.6. Release 0.243.3
13.185. Release 0.88
13.124. Release 0.144.5
13.192. Release 0.81
13.19. Release 0.238
13.155. Release 0.118
13.106. Release 0.157
13.47. Release 0.215
13.210. Release 0.63
13.81. Release 0.181
13.69. Release 0.193
13.62. Release 0.200
13.100. Release 0.162
13.102. Release 0.160
13.12. Release 0.241
13.70. Release 0.192
13.79. Release 0.183
13.71. Release 0.191
13.123. Release 0.144.6
13.170. Release 0.103
13.41. Release 0.221
13.146. Release 0.127
13.218. Release 0.55
13.74. Release 0.188
13.204. Release 0.69
13.129. Release 0.144
13.214. Release 0.59
13.21. Release 0.236
13.162. Release 0.111
13.156. Release 0.117
13.197. Release 0.76
13.194. Release 0.79
13.182. Release 0.91
13.95. Release 0.167
13.128. Release 0.144.1
13.99. Release 0.163
13.59. Release 0.203
13.40. Release 0.222
13.217. Release 0.56
13.145. Release 0.128
13.119. Release 0.147
13.96. Release 0.166
13.53. Release 0.209
13.13. Release 0.240
13.31. Release 0.231
13.90. Release 0.172
13.171. Release 0.102
13.83. Release 0.179
13.180. Release 0.93
13.73. Release 0.189
13.5. Release 0.243.4
13.36. Release 0.226
13.39. Release 0.223
13.148. Release 0.125
13.177. Release 0.96
13.114. Release 0.152
13.134. Release 0.139
13.206. Release 0.67
13.45. Release 0.217
13.109. Release 0.154
13.80. Release 0.182
13.130. Release 0.143
13.42. Release 0.220
13.166. Release 0.107
13.55. Release 0.207
13.139. Release 0.134
13.63. Release 0.199
13.173. Release 0.100
13.93. Release 0.169
13.199. Release 0.74
13.89. Release 0.173
13.157. Release 0.116
13.56. Release 0.206
13.8. Release 0.243.1
13.137. Release 0.136
13.64. Release 0.198
13.126. Release 0.144.3
13.86. Release 0.176
13.82. Release 0.180
13.94. Release 0.168
13.18. Release 0.238.2
13.25. Release 0.234.2
13.34. Release 0.228
13.190. Release 0.83
13.1. Release 0.245.1
13.15. Release 0.239.1
13.115. Release 0.151
13.175. Release 0.98
13.22. Release 0.235.1
13.135. Release 0.138
13.10. Release 0.242.1
13.107. Release 0.156
13.7. Release 0.243.2
13.174. Release 0.99
13.61. Release 0.201
13.66. Release 0.196
13.172. Release 0.101
13.209. Release 0.64
13.104. Release 0.158
13.120. Release 0.146
13.67. Release 0.195
13.122. Release 0.144.7
13.111. Release 0.152.3
12. Developer Guide
12.3. Example HTTP Connector
12.6. System Access Control
12.8. Event Listener
12.5. Functions
12.1. SPI Overview
12.2. Connectors
12.4. Types
12.7. Password Authenticator
9. SQL Language
9.2. Reserved Keywords
9.1. Data Types
1. Overview
1.2. Presto Concepts
1.1. Use Cases
8. Functions and Operators
8.2. Comparison Functions and Operators
8.16. Array Functions and Operators
8.21. HyperLogLog Functions
8.11. Binary Functions and Operators
8.27. Internationalization Functions
8.26. Teradata Functions
8.13. Date and Time Functions and Operators
8.14. Aggregate Functions
8.20. Geospatial Functions
8.17. Map Functions and Operators
8.10. Regular Expression Functions
8.1. Logical Operators
8.3. Conditional Expressions
8.23. Quantile Digest Functions
8.19. IP Functions
8.12. JSON Functions and Operators
8.22. KHyperLogLog Functions
8.9. String Functions and Operators
8.5. Conversion Functions
8.6. Mathematical Functions and Operators
8.4. Lambda Expressions
8.18. URL Functions
8.7. Bitwise Functions
8.25. Session Information
8.8. Decimal Functions and Operators
8.15. Window Functions
8.24. Color Functions
10. SQL Statement Syntax
10.19. DROP ROLE
10.11. CREATE TABLE AS
10.46. SHOW SCHEMAS
10.40. SHOW CREATE TABLE
10.28. INSERT
10.38. SHOW COLUMNS
10.10. CREATE TABLE
10.52. VALUES
10.16. DESCRIBE INPUT
10.17. DESCRIBE OUTPUT
10.43. SHOW GRANTS
10.3. ALTER TABLE
10.30. RESET SESSION
10.41. SHOW CREATE VIEW
10.35. SET ROLE
10.34. SELECT
10.25. EXPLAIN ANALYZE
10.42. SHOW FUNCTIONS
10.15. DESCRIBE
10.8. CREATE ROLE
10.14. DELETE
10.51. USE
10.1. ALTER FUNCTION
10.44. SHOW ROLE GRANTS
10.18. DROP FUNCTION
10.48. SHOW STATS
10.36. SET SESSION
10.33. ROLLBACK
10.29. PREPARE
10.13. DEALLOCATE PREPARE
10.9. CREATE SCHEMA
10.50. START TRANSACTION
10.12. CREATE VIEW
10.4. ANALYZE
10.23. EXECUTE
10.39. SHOW CREATE FUNCTION
10.5. CALL
10.37. SHOW CATALOGS
10.26. GRANT
10.24. EXPLAIN
10.7. CREATE FUNCTION
10.2. ALTER SCHEMA
10.31. REVOKE
10.22. DROP VIEW
10.49. SHOW TABLES
10.45. SHOW ROLES
10.32. REVOKE ROLES
10.27. GRANT ROLES
10.20. DROP SCHEMA
10.47. SHOW SESSION
10.6. COMMIT
10.21. DROP TABLE
7. Connectors
7.9. Kafka Connector
7.15. MySQL Connector
7.1. Accumulo Connector
7.2. Black Hole Connector
7.18. PostgreSQL Connector
7.20. Redshift Connector
7.23. Thrift Connector
7.12. Local File Connector
7.21. SQL Server Connector
7.10. Kafka Connector Tutorial
7.25. TPCH Connector
7.19. Redis Connector
7.5. Elasticsearch Connector
7.7. Hive Security Configuration
7.17. Pinot Connector
7.3. Cassandra Connector
7.14. MongoDB Connector
7.6. Hive Connector
7.11. Kudu Connector
7.22. System Connector
7.8. JMX Connector
7.24. TPCDS Connector
7.16. Oracle Connector
7.4. Druid Connector
7.13. Memory Connector
暂无相关搜索结果！
本文档使用
BookStack
构建
×
分享，让知识传承更久远
×
文章二维码
手机扫一扫，轻松掌上读
×
文档下载
请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
PDF
文档
EPUB
文档
MOBI
文档
×
微信小程序阅读
微信扫一扫，知识掌上学
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度
我的书签
添加书签
移除书签