MAPREDUCE服务 MRS-CREATE TABLE AS:语法

时间：2024-07-02 16:39:46

MAPREDUCE服务 MRS HetuEngine DDL SQL语法说明

CREATE [EXTERNAL]^① TABLE [IF NOT EXISTS] [catalog_name.][db_name.]table_name [ ( column_alias, ... ) ]

[[PARTITIONED BY^①(col_name, ....)] [SORT BY^① ([column [, column ...]])] ]^①

[COMMENT 'table_comment']

[ WITH ( property_name = expression [, ...] ) ]^②

[[STORED AS file_format]^①

[LOCATION 'hdfs_path']^①

[TBLPROPERTIES (orc_table_property = value [, ...] ) ] ]^①

AS query

[ WITH [ NO ] DATA ]^②

MAPREDUCE服务 MRS-CREATE TABLE AS:语法

意见反馈

0/200

提交成功！非常感谢您的反馈，我们会继续努力做到更好反馈提交失败！请稍后重试！

推荐文章

7*24