×
思维导图备注
Presto 0.234 Documentation
首页
白天
夜间
小程序
阅读
书签
我的书签
添加书签
移除书签
8. SQL Language
Github
来源:Presto
浏览
425
扫码
分享
2020-04-20 22:50:26
8. SQL Language
8. SQL Language
8.1. Data Types
8.2. Reserved Keywords
当前内容版权归
Presto
或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问
Presto
.
上一篇:
下一篇:
版本
Presto v0.289 Documentation
Presto v0.285 Documentation
Presto v0.280 Documentation
Presto 0.275 Documentation
Presto 0.272.1 Documentation
Presto 0.268 Documentation
Presto 0.257 Documentation
Presto 0.245.1 Documentation
Presto 0.242 Documentation
Presto 0.237 Documentation
Presto 0.236 Documentation
Presto 0.234 Documentation
Presto 0.229 Documentation
Presto 0.221 Documentation
Presto 0.220 Documentation
Presto 0.206 Documentation
1. Overview
1.1. Use Cases
1.2. Presto Concepts
2. Installation
2.1. Deploying Presto
2.2. Command Line Interface
2.3. JDBC Driver
2.4. Benchmark Driver
2.5. Web Connector for Tableau
3. Security
3.1. Coordinator Kerberos Authentication
3.2. CLI Kerberos Authentication
3.3. LDAP Authentication
3.4. Java Keystores and Truststores
3.5. Built-in System Access Control
3.6. Secure Internal Communication
4. Administration
4.1. Web Interface
4.2. Tuning Presto
4.3. Properties Reference
4.4. Spill to Disk
4.5. Resource Groups
4.6. Session Property Managers
4.7. Function Namespace Managers
4.8. Distributed sort
4.9. Presto Verifier
5. Query Optimizer
5.1. Table Statistics
5.2. Cost in EXPLAIN
5.3. Cost based optimizations
6. Connectors
6.1. Accumulo Connector
6.2. Black Hole Connector
6.3. Cassandra Connector
6.4. Druid Connector
6.5. Elasticsearch Connector
6.6. Hive Connector
6.7. Hive Security Configuration
6.8. JMX Connector
6.9. Kafka Connector
6.10. Kafka Connector Tutorial
6.11. Kudu Connector
6.12. Local File Connector
6.13. Memory Connector
6.14. MongoDB Connector
6.15. MySQL Connector
6.16. Pinot Connector
6.17. PostgreSQL Connector
6.18. Redis Connector
6.19. Redshift Connector
6.20. SQL Server Connector
6.21. System Connector
6.22. Thrift Connector
6.23. TPCDS Connector
6.24. TPCH Connector
7. Functions and Operators
7.1. Logical Operators
7.2. Comparison Functions and Operators
7.3. Conditional Expressions
7.4. Lambda Expressions
7.5. Conversion Functions
7.6. Mathematical Functions and Operators
7.7. Bitwise Functions
7.8. Decimal Functions and Operators
7.9. String Functions and Operators
7.10. Regular Expression Functions
7.11. Binary Functions and Operators
7.12. JSON Functions and Operators
7.13. Date and Time Functions and Operators
7.14. Aggregate Functions
7.15. Window Functions
7.16. Array Functions and Operators
7.17. Map Functions and Operators
7.18. URL Functions
7.19. IP Functions
7.20. Geospatial Functions
7.21. HyperLogLog Functions
7.22. KHyperLogLog Functions
7.23. Quantile Digest Functions
7.24. Color Functions
7.25. Session Information
7.26. Teradata Functions
8. SQL Language
8.1. Data Types
8.2. Reserved Keywords
9. SQL Statement Syntax
9.1. ALTER FUNCTION
9.2. ALTER SCHEMA
9.3. ALTER TABLE
9.4. ANALYZE
9.5. CALL
9.6. COMMIT
9.7. CREATE FUNCTION
9.8. CREATE ROLE
9.9. CREATE SCHEMA
9.10. CREATE TABLE
9.11. CREATE TABLE AS
9.12. CREATE VIEW
9.13. DEALLOCATE PREPARE
9.14. DELETE
9.15. DESCRIBE
9.16. DESCRIBE INPUT
9.17. DESCRIBE OUTPUT
9.18. DROP FUNCTION
9.19. DROP ROLE
9.20. DROP SCHEMA
9.21. DROP TABLE
9.22. DROP VIEW
9.23. EXECUTE
9.24. EXPLAIN
9.25. EXPLAIN ANALYZE
9.26. GRANT
9.27. GRANT ROLES
9.28. INSERT
9.29. PREPARE
9.30. RESET SESSION
9.31. REVOKE
9.32. REVOKE ROLES
9.33. ROLLBACK
9.34. SELECT
9.35. SET ROLE
9.36. SET SESSION
9.37. SHOW CATALOGS
9.38. SHOW COLUMNS
9.39. SHOW CREATE TABLE
9.40. SHOW CREATE VIEW
9.41. SHOW FUNCTIONS
9.42. SHOW GRANTS
9.43. SHOW ROLE GRANTS
9.44. SHOW ROLES
9.45. SHOW SCHEMAS
9.46. SHOW SESSION
9.47. SHOW STATS
9.48. SHOW TABLES
9.49. START TRANSACTION
9.50. USE
9.51. VALUES
10. Migration
10.1. Migrating From Hive
11. Developer Guide
11.1. SPI Overview
11.2. Connectors
11.3. Example HTTP Connector
11.4. Types
11.5. Functions
11.6. System Access Control
11.7. Password Authenticator
11.8. Event Listener
12. Release Notes
12.1. Release 0.234
12.2. Release 0.233.1
12.3. Release 0.233
12.4. Release 0.232
12.5. Release 0.231
12.6. Release 0.230
12.7. Release 0.229
12.8. Release 0.228
12.9. Release 0.227
12.10. Release 0.226
12.11. Release 0.225
12.12. Release 0.224
12.13. Release 0.223
12.14. Release 0.222
12.15. Release 0.221
12.16. Release 0.220
12.17. Release 0.219
12.18. Release 0.218
12.19. Release 0.217
12.20. Release 0.216
12.21. Release 0.215
12.22. Release 0.214
12.23. Release 0.213
12.24. Release 0.212
12.25. Release 0.211
12.26. Release 0.210
12.27. Release 0.209
12.28. Release 0.208
12.29. Release 0.207
12.30. Release 0.206
12.31. Release 0.205
12.32. Release 0.204
12.33. Release 0.203
12.34. Release 0.202
12.35. Release 0.201
12.36. Release 0.200
12.37. Release 0.199
12.38. Release 0.198
12.39. Release 0.197
12.40. Release 0.196
12.41. Release 0.195
12.42. Release 0.194
12.43. Release 0.193
12.44. Release 0.192
12.45. Release 0.191
12.46. Release 0.190
12.47. Release 0.189
12.48. Release 0.188
12.49. Release 0.187
12.50. Release 0.186
12.51. Release 0.185
12.52. Release 0.184
12.53. Release 0.183
12.54. Release 0.182
12.55. Release 0.181
12.56. Release 0.180
12.57. Release 0.179
12.58. Release 0.178
12.59. Release 0.177
12.60. Release 0.176
12.61. Release 0.175
12.62. Release 0.174
12.63. Release 0.173
12.64. Release 0.172
12.65. Release 0.171
12.66. Release 0.170
12.67. Release 0.169
12.68. Release 0.168
12.69. Release 0.167
12.70. Release 0.166
12.71. Release 0.165
12.72. Release 0.164
12.73. Release 0.163
12.74. Release 0.162
12.75. Release 0.161
12.76. Release 0.160
12.77. Release 0.159
12.78. Release 0.158
12.79. Release 0.157.1
12.80. Release 0.157
12.81. Release 0.156
12.82. Release 0.155
12.83. Release 0.154
12.84. Release 0.153
12.85. Release 0.152.3
12.86. Release 0.152.2
12.87. Release 0.152.1
12.88. Release 0.152
12.89. Release 0.151
12.90. Release 0.150
12.91. Release 0.149
12.92. Release 0.148
12.93. Release 0.147
12.94. Release 0.146
12.95. Release 0.145
12.96. Release 0.144.7
12.97. Release 0.144.6
12.98. Release 0.144.5
12.99. Release 0.144.4
12.100. Release 0.144.3
12.101. Release 0.144.2
12.102. Release 0.144.1
12.103. Release 0.144
12.104. Release 0.143
12.105. Release 0.142
12.106. Release 0.141
12.107. Release 0.140
12.108. Release 0.139
12.109. Release 0.138
12.110. Release 0.137
12.111. Release 0.136
12.112. Release 0.135
12.113. Release 0.134
12.114. Release 0.133
12.115. Release 0.132
12.116. Release 0.131
12.117. Release 0.130
12.118. Release 0.129
12.119. Release 0.128
12.120. Release 0.127
12.121. Release 0.126
12.122. Release 0.125
12.123. Release 0.124
12.124. Release 0.123
12.125. Release 0.122
12.126. Release 0.121
12.127. Release 0.120
12.128. Release 0.119
12.129. Release 0.118
12.130. Release 0.117
12.131. Release 0.116
12.132. Release 0.115
12.133. Release 0.114
12.134. Release 0.113
12.135. Release 0.112
12.136. Release 0.111
12.137. Release 0.110
12.138. Release 0.109
12.139. Release 0.108
12.140. Release 0.107
12.141. Release 0.106
12.142. Release 0.105
12.143. Release 0.104
12.144. Release 0.103
12.145. Release 0.102
12.146. Release 0.101
12.147. Release 0.100
12.148. Release 0.99
12.149. Release 0.98
12.150. Release 0.97
12.151. Release 0.96
12.152. Release 0.95
12.153. Release 0.94
12.154. Release 0.93
12.155. Release 0.92
12.156. Release 0.91
12.157. Release 0.90
12.158. Release 0.89
12.159. Release 0.88
12.160. Release 0.87
12.161. Release 0.86
12.162. Release 0.85
12.163. Release 0.84
12.164. Release 0.83
12.165. Release 0.82
12.166. Release 0.81
12.167. Release 0.80
12.168. Release 0.79
12.169. Release 0.78
12.170. Release 0.77
12.171. Release 0.76
12.172. Release 0.75
12.173. Release 0.74
12.174. Release 0.73
12.175. Release 0.72
12.176. Release 0.71
12.177. Release 0.70
12.178. Release 0.69
12.179. Release 0.68
12.180. Release 0.67
12.181. Release 0.66
12.182. Release 0.65
12.183. Release 0.64
12.184. Release 0.63
12.185. Release 0.62
12.186. Release 0.61
12.187. Release 0.60
12.188. Release 0.59
12.189. Release 0.58
12.190. Release 0.57
12.191. Release 0.56
12.192. Release 0.55
12.193. Release 0.54
暂无相关搜索结果!
本文档使用
BookStack
构建
×
分享,让知识传承更久远
×
文章二维码
手机扫一扫,轻松掌上读
×
文档下载
普通下载
下载码下载(免登录无限下载)
你与大神的距离,只差一个APP
请下载您需要的格式的文档,随时随地,享受汲取知识的乐趣!
PDF
文档
EPUB
文档
MOBI
文档
温馨提示
每天每在网站阅读学习一分钟时长可下载一本电子书,每天连续签到可增加阅读时长
下载码方式下载:免费、免登录、无限制。
免费获取下载码
下载码
文档格式
PDF
EPUB
MOBI
码上下载
×
微信小程序阅读
您与他人的薪资差距,只差一个随时随地学习的小程序
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度