思维导图备注

Presto v0.289 Documentation
首页 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

SQL Language

 Github  来源:Facebook 浏览 42 扫码 分享 2024-10-11 16:35:34
  • SQL Language

    SQL Language

    • Data Types
    • Reserved Keywords
    当前内容版权归 Facebook 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 Facebook .
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • 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
    • Overview
      • Use Cases
      • Presto Concepts
    • Installation
      • Deploying Presto
      • Command Line Interface
      • JDBC Driver
      • Benchmark Driver
      • Web Connector for Tableau
      • Executing Presto on Spark
      • Deploy Presto From a Docker Image
      • Deploy Presto on a Mac using Homebrew
      • Deploy Presto Using Helm Charts
    • Presto Clients
      • Command Line Interface
      • Presto Console
      • DBeaver
      • Apache Superset
    • Security
      • Coordinator Kerberos Authentication
      • CLI Kerberos Authentication
      • LDAP Authentication
      • Password File Authentication
      • Java Keystores and Truststores
      • Built-in System Access Control
      • Secure Internal Communication
      • Authorization
    • Administration
      • Web Interface
      • Tuning Presto
      • Properties Reference
      • Spill to Disk
      • Exchange Materialization
      • CTE Materialization
      • Resource Groups
      • Session Property Managers
      • Function Namespace Managers
      • Distributed sort
      • Presto Verifier
    • Cache
      • Alluxio SDK Cache
      • Alluxio Cache Service
    • Query Optimizer
      • Table Statistics
      • Cost in EXPLAIN
      • Cost based optimizations
      • History based optimizations (HBO)
      • Logical Properties of Query Plans
    • Connectors
      • Accumulo Connector
      • BigQuery Connector
      • Black Hole Connector
      • Cassandra Connector
      • ClickHouse connector
      • Delta Lake Connector
      • Druid Connector
      • Elasticsearch Connector
      • Google Sheets connector
      • HANA Connector
      • Hive Connector
      • Hive Security Configuration
      • Hudi Connector
      • Iceberg Connector
      • JMX Connector
      • Kafka Connector
      • Kafka Connector Tutorial
      • Kudu Connector
      • Lark Sheets connector
      • Local File Connector
      • Memory Connector
      • MongoDB Connector
      • MySQL Connector
      • Oracle Connector
      • Apache Pinot Connector
      • PostgreSQL Connector
      • Prometheus Connector
      • Redis Connector
      • Redshift Connector
      • ScyllaDB Connector
      • SingleStore Connector
      • SQL Server Connector
      • System Connector
      • Thrift Connector
      • TPCDS Connector
      • TPCH Connector
    • Plugins
      • Redis HBO Provider
    • Functions and Operators
      • Logical Operators
      • Comparison Functions and Operators
      • Conditional Expressions
      • Lambda Expressions
      • Conversion Functions
      • Mathematical Functions and Operators
      • Bitwise Functions
      • Decimal Functions and Operators
      • String Functions and Operators
      • Regular Expression Functions
      • Binary Functions and Operators
      • JSON Functions and Operators
      • Date and Time Functions and Operators
      • Aggregate Functions
      • Noisy Aggregate Functions
      • Window Functions
      • Array Functions and Operators
      • Map Functions and Operators
      • URL Functions
      • IP Functions
      • Geospatial Functions
      • HyperLogLog Functions
      • KHyperLogLog Functions
      • Quantile Digest Functions
      • UUID functions
      • T-Digest Functions
      • Color Functions
      • Session Information
      • Teradata Functions
      • Internationalization Functions
      • Set Digest functions
      • Sketch Functions
      • Pinot Functions
    • SQL Language
      • Data Types
      • Reserved Keywords
    • SQL Statement Syntax
      • ALTER FUNCTION
      • ALTER SCHEMA
      • ALTER TABLE
      • ANALYZE
      • CALL
      • COMMIT
      • CREATE FUNCTION
      • CREATE ROLE
      • CREATE SCHEMA
      • CREATE TABLE
      • CREATE TABLE AS
      • CREATE VIEW
      • DEALLOCATE PREPARE
      • DELETE
      • DESCRIBE
      • DESCRIBE INPUT
      • DESCRIBE OUTPUT
      • DROP FUNCTION
      • DROP ROLE
      • DROP SCHEMA
      • DROP TABLE
      • DROP VIEW
      • EXECUTE
      • EXPLAIN
      • EXPLAIN ANALYZE
      • GRANT
      • GRANT ROLES
      • INSERT
      • PREPARE
      • RESET SESSION
      • REVOKE
      • REVOKE ROLES
      • ROLLBACK
      • SELECT
      • SET ROLE
      • SET SESSION
      • SHOW CATALOGS
      • SHOW COLUMNS
      • SHOW CREATE FUNCTION
      • SHOW CREATE TABLE
      • SHOW CREATE VIEW
      • SHOW FUNCTIONS
      • SHOW GRANTS
      • SHOW ROLE GRANTS
      • SHOW ROLES
      • SHOW SCHEMAS
      • SHOW SESSION
      • SHOW STATS
      • SHOW TABLES
      • START TRANSACTION
      • TRUNCATE
      • UPDATE
      • USE
      • VALUES
    • Migration
      • Migrating From Hive
    • REST API
      • Node Resource
      • Query Resource
      • Stage Resource
      • Statement Resource
      • Task Resource
    • Ecosystem
      • Ecosystem
    • Router
      • Deploying Presto Router
      • Router Schedulers
    • Developer Guide
      • SPI Overview
      • Connectors
      • Example HTTP Connector
      • Supporting DELETE and UPDATE
      • Types
      • Functions
      • System Access Control
      • Password Authenticator
      • Event Listener
      • Presto Client REST API
      • Presto Worker REST API
      • SerializedPage Wire Format
      • Presto Console
    • Presto C++
      • Presto C++ Features
      • Presto C++ Limitations
      • Presto C++ Properties Reference
      • Overview
      • Motivation and Vision
      • Supported Use Cases
    • Release Notes
      • Release-0.289 [2024-08-23]
      • Release-0.288.1 [2024-08-12]
      • Release-0.288 [2024-06-13]
      • Release-0.287 [2024-04-16]
      • Release-0.286 [2024-02-12]
      • Release-0.285.1 [2023-12-30]
      • Release-0.285 [2023-12-08]
      • Release-0.284 [2023-10-11]
      • Release-0.283 [2023-08-08]
      • Release 0.282
      • Release 0.281
      • Release 0.280
      • Release 0.279.2
      • Release 0.279
      • Release 0.278.1
      • Release 0.278
      • Release 0.277
      • Release 0.276.1
      • Release 0.276
      • Release 0.275
      • Release 0.274
      • Release 0.273.3
      • Release 0.273.2
      • Release 0.273
      • Release 0.272
      • Release 0.271
      • Release 0.270
      • Release 0.269
      • Release 0.268
      • Release 0.267
      • Release 0.266
      • Release 0.265
      • Release 0.264.1
      • Release 0.264
      • Release 0.263.1
      • Release 0.263
      • Release 0.262
      • Release 0.261
      • Release 0.260.1
      • Release 0.260
      • Release 0.259.1
      • Release 0.259
      • Release 0.258
      • Release 0.257
      • Release 0.256
      • Release 0.255
      • Release 0.254.1
      • Release 0.254
      • Release 0.253.1
      • Release 0.253
      • Release 0.252
      • Release 0.251.1
      • Release 0.251
      • Release 0.250
      • Release 0.249.2
      • Release 0.249.1
      • Release 0.249
      • Release 0.248.1
      • Release 0.248
      • Release 0.247
      • Release 0.246
      • Release 0.245.1
      • Release 0.245
      • Release 0.244.1
      • Release 0.244
      • Release 0.243.4
      • Release 0.243.3
      • Release 0.243.2
      • Release 0.243.1
      • Release 0.243
      • Release 0.242.1
      • Release 0.242
      • Release 0.241
      • Release 0.240
      • Release 0.239.2
      • Release 0.239.1
      • Release 0.239
      • Release 0.238.3
      • Release 0.238.2
      • Release 0.238
      • Release 0.237
      • Release 0.236
      • Release 0.235.1
      • Release 0.235
      • Release 0.234.3
      • Release 0.234.2
      • Release 0.234.1
      • Release 0.234
      • Release 0.233.1
      • Release 0.233
      • Release 0.232
      • Release 0.231
      • Release 0.230
      • Release 0.229
      • Release 0.228
      • Release 0.227
      • Release 0.226
      • Release 0.225
      • Release 0.224
      • Release 0.223
      • Release 0.222
      • Release 0.221
      • Release 0.220
      • Release 0.219
      • Release 0.218
      • Release 0.217
      • Release 0.216
      • Release 0.215
      • Release 0.214
      • Release 0.213
      • Release 0.212
      • Release 0.211
      • Release 0.210
      • Release 0.209
      • Release 0.208
      • Release 0.207
      • Release 0.206
      • Release 0.205
      • Release 0.204
      • Release 0.203
      • Release 0.202
      • Release 0.201
      • Release 0.200
      • Release 0.199
      • Release 0.198
      • Release 0.197
      • Release 0.196
      • Release 0.195
      • Release 0.194
      • Release 0.193
      • Release 0.192
      • Release 0.191
      • Release 0.190
      • Release 0.189
      • Release 0.188
      • Release 0.187
      • Release 0.186
      • Release 0.185
      • Release 0.184
      • Release 0.183
      • Release 0.182
      • Release 0.181
      • Release 0.180
      • Release 0.179
      • Release 0.178
      • Release 0.177
      • Release 0.176
      • Release 0.175
      • Release 0.174
      • Release 0.173
      • Release 0.172
      • Release 0.171
      • Release 0.170
      • Release 0.169
      • Release 0.168
      • Release 0.167
      • Release 0.166
      • Release 0.165
      • Release 0.164
      • Release 0.163
      • Release 0.162
      • Release 0.161
      • Release 0.160
      • Release 0.159
      • Release 0.158
      • Release 0.157.1
      • Release 0.157
      • Release 0.156
      • Release 0.155
      • Release 0.154
      • Release 0.153
      • Release 0.152.3
      • Release 0.152.2
      • Release 0.152.1
      • Release 0.152
      • Release 0.151
      • Release 0.150
      • Release 0.149
      • Release 0.148
      • Release 0.147
      • Release 0.146
      • Release 0.145
      • Release 0.144.7
      • Release 0.144.6
      • Release 0.144.5
      • Release 0.144.4
      • Release 0.144.3
      • Release 0.144.2
      • Release 0.144.1
      • Release 0.144
      • Release 0.143
      • Release 0.142
      • Release 0.141
      • Release 0.140
      • Release 0.139
      • Release 0.138
      • Release 0.137
      • Release 0.136
      • Release 0.135
      • Release 0.134
      • Release 0.133
      • Release 0.132
      • Release 0.131
      • Release 0.130
      • Release 0.129
      • Release 0.128
      • Release 0.127
      • Release 0.126
      • Release 0.125
      • Release 0.124
      • Release 0.123
      • Release 0.122
      • Release 0.121
      • Release 0.120
      • Release 0.119
      • Release 0.118
      • Release 0.117
      • Release 0.116
      • Release 0.115
      • Release 0.114
      • Release 0.113
      • Release 0.112
      • Release 0.111
      • Release 0.110
      • Release 0.109
      • Release 0.108
      • Release 0.107
      • Release 0.106
      • Release 0.105
      • Release 0.104
      • Release 0.103
      • Release 0.102
      • Release 0.101
      • Release 0.100
      • Release 0.99
      • Release 0.98
      • Release 0.97
      • Release 0.96
      • Release 0.95
      • Release 0.94
      • Release 0.93
      • Release 0.92
      • Release 0.91
      • Release 0.90
      • Release 0.89
      • Release 0.88
      • Release 0.87
      • Release 0.86
      • Release 0.85
      • Release 0.84
      • Release 0.83
      • Release 0.82
      • Release 0.81
      • Release 0.80
      • Release 0.79
      • Release 0.78
      • Release 0.77
      • Release 0.76
      • Release 0.75
      • Release 0.74
      • Release 0.73
      • Release 0.72
      • Release 0.71
      • Release 0.70
      • Release 0.69
      • Release 0.68
      • Release 0.67
      • Release 0.66
      • Release 0.65
      • Release 0.64
      • Release 0.63
      • Release 0.62
      • Release 0.61
      • Release 0.60
      • Release 0.59
      • Release 0.58
      • Release 0.57
      • Release 0.56
      • Release 0.55
      • Release 0.54
    暂无相关搜索结果！

      本文档使用 BookStack 构建

      展开/收起文章目录

      分享，让知识传承更久远

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      • 普通下载
      • 下载码下载(免登录无限下载)
      你与大神的距离，只差一个APP
      APP下载
      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档
      温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
      下载码方式下载：免费、免登录、无限制。 免费获取下载码

      微信小程序阅读

      BookChat 微信小程序阅读
      您与他人的薪资差距，只差一个随时随地学习的小程序

      书签列表

        阅读记录

        阅读进度: 0.00% ( 0/0 ) 重置阅读进度