MapReduce服务 MRS-CREATE TABLE:语法
语法
CREATE [EXTERNAL]①,② TABLE [IF NOT EXISTS] [catalog_name.][db_name.]table_name (
{ [col_name data_type [COMMENT col_comment] [ WITH③ ( property_name = expression [, ...] )③ ]
| LIKE③ existing_table_name [ {INCLUDING | EXCLUDING}③ PROPERTIES]③ } [, ...])
[[PARTITIONED BY①(col_name data_type, ....)] [SORT BY① ([column [, column ...]])] ]①
[COMMENT 'table_comment']
[ WITH ( property_name = expression [, ...] ) ]③
[[PARTITIONED BY② (col_name data_type, .....)] [CLUSTERED BY② (col_name, col_name, ...) [SORTED BY②③ (col_name, col_name, ...)] INTO num_buckets BUCKETS]② ]②
[
[ROW FORMAT row_format]
[STORED AS file_format]
[LOCATION 'hdfs_path']
[TBLPROPERTIES (orc_table_property = value [, ...] ) ] ]①,②
- MapReduce服务_什么是ClickHouse_如何使用ClickHouse
- GaussDB数据库SQL语法_SQL语法_CREATE_ALTER
- MapReduce服务_什么是MapReduce服务_什么是HBase
- Hudi服务_什么是Hudi_如何使用Hudi
- GaussDB(DWS)常用SQL_常用SQL命令_SQL语法
- MapReduce服务_什么是Loader_如何使用Loader
- MapReduce服务_如何使用MapReduce服务_MRS集群客户端安装与使用
- GaussDB数据库产品特性_华为gaussdb_高斯语法
- MRS备份恢复_MapReduce备份_数据备份
- 什么是Spark_如何使用Spark_Spark的功能是什么