×
思维导图备注
Presto 0.229 Documentation
首页
白天
夜间
小程序
阅读
书签
我的书签
添加书签
移除书签
7. SQL Language
Github
来源:PrestoDB
浏览
512
扫码
分享
2019-11-30 14:21:46
7. SQL Language
7. SQL Language
7.1. Data Types
7.2. Reserved Keywords
当前内容版权归
PrestoDB
或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问
PrestoDB
.
上一篇:
下一篇:
版本
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. Presto Verifier
2.5. Benchmark Driver
2.6. 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. Distributed sort
5. Connectors
5.1. Accumulo Connector
5.2. Black Hole Connector
5.3. Cassandra Connector
5.4. Elasticsearch Connector
5.5. Hive Connector
5.6. Hive Security Configuration
5.7. JMX Connector
5.8. Kafka Connector
5.9. Kafka Connector Tutorial
5.10. Kudu Connector
5.11. Local File Connector
5.12. Memory Connector
5.13. MongoDB Connector
5.14. MySQL Connector
5.15. Pinot Connector
5.16. PostgreSQL Connector
5.17. Redis Connector
5.18. Redshift Connector
5.19. SQL Server Connector
5.20. System Connector
5.21. Thrift Connector
5.22. TPCDS Connector
5.23. TPCH Connector
6. Functions and Operators
6.1. Logical Operators
6.2. Comparison Functions and Operators
6.3. Conditional Expressions
6.4. Lambda Expressions
6.5. Conversion Functions
6.6. Mathematical Functions and Operators
6.7. Bitwise Functions
6.8. Decimal Functions and Operators
6.9. String Functions and Operators
6.10. Regular Expression Functions
6.11. Binary Functions and Operators
6.12. JSON Functions and Operators
6.13. Date and Time Functions and Operators
6.14. Aggregate Functions
6.15. Window Functions
6.16. Array Functions and Operators
6.17. Map Functions and Operators
6.18. URL Functions
6.19. IP Functions
6.20. Geospatial Functions
6.21. HyperLogLog Functions
6.22. Quantile Digest Functions
6.23. Color Functions
6.24. Session Information
6.25. Teradata Functions
7. SQL Language
7.1. Data Types
7.2. Reserved Keywords
8. SQL Statement Syntax
8.1. ALTER SCHEMA
8.2. ALTER TABLE
8.3. ANALYZE
8.4. CALL
8.5. COMMIT
8.6. CREATE ROLE
8.7. CREATE SCHEMA
8.8. CREATE TABLE
8.9. CREATE TABLE AS
8.10. CREATE VIEW
8.11. DEALLOCATE PREPARE
8.12. DELETE
8.13. DESCRIBE
8.14. DESCRIBE INPUT
8.15. DESCRIBE OUTPUT
8.16. DROP ROLE
8.17. DROP SCHEMA
8.18. DROP TABLE
8.19. DROP VIEW
8.20. EXECUTE
8.21. EXPLAIN
8.22. EXPLAIN ANALYZE
8.23. GRANT
8.24. GRANT ROLES
8.25. INSERT
8.26. PREPARE
8.27. RESET SESSION
8.28. REVOKE
8.29. REVOKE ROLES
8.30. ROLLBACK
8.31. SELECT
8.32. SET ROLE
8.33. SET SESSION
8.34. SHOW CATALOGS
8.35. SHOW COLUMNS
8.36. SHOW CREATE TABLE
8.37. SHOW CREATE VIEW
8.38. SHOW FUNCTIONS
8.39. SHOW GRANTS
8.40. SHOW ROLE GRANTS
8.41. SHOW ROLES
8.42. SHOW SCHEMAS
8.43. SHOW SESSION
8.44. SHOW STATS
8.45. SHOW TABLES
8.46. START TRANSACTION
8.47. USE
8.48. VALUES
9. Migration
9.1. Migrating From Hive
10. Developer Guide
10.1. SPI Overview
10.2. Connectors
10.3. Example HTTP Connector
10.4. Types
10.5. Functions
10.6. System Access Control
10.7. Password Authenticator
10.8. Event Listener
11. Release Notes
11.1. Release 0.229
11.2. Release 0.228
11.3. Release 0.227
11.4. Release 0.226
11.5. Release 0.225
11.6. Release 0.224
11.7. Release 0.223
11.8. Release 0.222
11.9. Release 0.221
11.10. Release 0.220
11.11. Release 0.219
11.12. Release 0.218
11.13. Release 0.217
11.14. Release 0.216
11.15. Release 0.215
11.16. Release 0.214
11.17. Release 0.213
11.18. Release 0.212
11.19. Release 0.211
11.20. Release 0.210
11.21. Release 0.209
11.22. Release 0.208
11.23. Release 0.207
11.24. Release 0.206
11.25. Release 0.205
11.26. Release 0.204
11.27. Release 0.203
11.28. Release 0.202
11.29. Release 0.201
11.30. Release 0.200
11.31. Release 0.199
11.32. Release 0.198
11.33. Release 0.197
11.34. Release 0.196
11.35. Release 0.195
11.36. Release 0.194
11.37. Release 0.193
11.38. Release 0.192
11.39. Release 0.191
11.40. Release 0.190
11.41. Release 0.189
11.42. Release 0.188
11.43. Release 0.187
11.44. Release 0.186
11.45. Release 0.185
11.46. Release 0.184
11.47. Release 0.183
11.48. Release 0.182
11.49. Release 0.181
11.50. Release 0.180
11.51. Release 0.179
11.52. Release 0.178
11.53. Release 0.177
11.54. Release 0.176
11.55. Release 0.175
11.56. Release 0.174
11.57. Release 0.173
11.58. Release 0.172
11.59. Release 0.171
11.60. Release 0.170
11.61. Release 0.169
11.62. Release 0.168
11.63. Release 0.167
11.64. Release 0.166
11.65. Release 0.165
11.66. Release 0.164
11.67. Release 0.163
11.68. Release 0.162
11.69. Release 0.161
11.70. Release 0.160
11.71. Release 0.159
11.72. Release 0.158
11.73. Release 0.157.1
11.74. Release 0.157
11.75. Release 0.156
11.76. Release 0.155
11.77. Release 0.154
11.78. Release 0.153
11.79. Release 0.152.3
11.80. Release 0.152.2
11.81. Release 0.152.1
11.82. Release 0.152
11.83. Release 0.151
11.84. Release 0.150
11.85. Release 0.149
11.86. Release 0.148
11.87. Release 0.147
11.88. Release 0.146
11.89. Release 0.145
11.90. Release 0.144.7
11.91. Release 0.144.6
11.92. Release 0.144.5
11.93. Release 0.144.4
11.94. Release 0.144.3
11.95. Release 0.144.2
11.96. Release 0.144.1
11.97. Release 0.144
11.98. Release 0.143
11.99. Release 0.142
11.100. Release 0.141
11.101. Release 0.140
11.102. Release 0.139
11.103. Release 0.138
11.104. Release 0.137
11.105. Release 0.136
11.106. Release 0.135
11.107. Release 0.134
11.108. Release 0.133
11.109. Release 0.132
11.110. Release 0.131
11.111. Release 0.130
11.112. Release 0.129
11.113. Release 0.128
11.114. Release 0.127
11.115. Release 0.126
11.116. Release 0.125
11.117. Release 0.124
11.118. Release 0.123
11.119. Release 0.122
11.120. Release 0.121
11.121. Release 0.120
11.122. Release 0.119
11.123. Release 0.118
11.124. Release 0.117
11.125. Release 0.116
11.126. Release 0.115
11.127. Release 0.114
11.128. Release 0.113
11.129. Release 0.112
11.130. Release 0.111
11.131. Release 0.110
11.132. Release 0.109
11.133. Release 0.108
11.134. Release 0.107
11.135. Release 0.106
11.136. Release 0.105
11.137. Release 0.104
11.138. Release 0.103
11.139. Release 0.102
11.140. Release 0.101
11.141. Release 0.100
11.142. Release 0.99
11.143. Release 0.98
11.144. Release 0.97
11.145. Release 0.96
11.146. Release 0.95
11.147. Release 0.94
11.148. Release 0.93
11.149. Release 0.92
11.150. Release 0.91
11.151. Release 0.90
11.152. Release 0.89
11.153. Release 0.88
11.154. Release 0.87
11.155. Release 0.86
11.156. Release 0.85
11.157. Release 0.84
11.158. Release 0.83
11.159. Release 0.82
11.160. Release 0.81
11.161. Release 0.80
11.162. Release 0.79
11.163. Release 0.78
11.164. Release 0.77
11.165. Release 0.76
11.166. Release 0.75
11.167. Release 0.74
11.168. Release 0.73
11.169. Release 0.72
11.170. Release 0.71
11.171. Release 0.70
11.172. Release 0.69
11.173. Release 0.68
11.174. Release 0.67
11.175. Release 0.66
11.176. Release 0.65
11.177. Release 0.64
11.178. Release 0.63
11.179. Release 0.62
11.180. Release 0.61
11.181. Release 0.60
11.182. Release 0.59
11.183. Release 0.58
11.184. Release 0.57
11.185. Release 0.56
11.186. Release 0.55
11.187. Release 0.54
暂无相关搜索结果！
本文档使用
BookStack
构建
×
分享，让知识传承更久远
×
文章二维码
手机扫一扫，轻松掌上读
×
文档下载
普通下载
下载码下载(免登录无限下载)
你与大神的距离，只差一个APP
请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
PDF
文档
EPUB
文档
MOBI
文档
温馨提示
每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
下载码方式下载：免费、免登录、无限制。
免费获取下载码
下载码
文档格式
PDF
EPUB
MOBI
码上下载
×
微信小程序阅读
您与他人的薪资差距，只差一个随时随地学习的小程序
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度
我的书签
添加书签
移除书签
