数智融合计算服务 DATAARTSFABRIC-CREATE EXTERNAL TABLE:语法格式

时间:2025-06-17 08:50:05

语法格式

1
2
3
4
5
6
7
8
9
CREATE EXTERNAL TABLE [ IF NOT EXISTS ] [schema_name.]table_name 
[ ( col_name col_type [ COMMENT col_comment ] [, ... ] ) ]
[ COMMENT table_comment ]
[ PARTITION BY ( col_name col_type COMMENT col_comment [, ... ] ) ]
[ CLUSTERED BY (col_name [,...]) INTO ( bucket_num ) BUCKETS ]
[ TABLEPROPERTIES ( option_key = option_value [, ... ] ) ]
[ STORE AS table_format ]
[ LOCATION table_path ]
AS select_stmt;
support.huaweicloud.com/devg-fabric/dataartsfabric_sql_04_0288.html