数据湖探索 DLI-使用DataSource语法创建OBS表:语法格式

时间:2024-07-27 14:12:11

语法格式

1
2
3
4
5
6
7
CREATE TABLE [IF NOT EXISTS] [db_name.]table_name 
  [(col_name1 col_type1 [COMMENT col_comment1], ...)]
  USING file_format 
  [OPTIONS (path 'obs_path', key1=val1, key2=val2, ...)] 
  [PARTITIONED BY (col_name1, col_name2, ...)]
  [COMMENT table_comment]
  [AS select_statement]
support.huaweicloud.com/sqlreference-dli/dli_08_0076.html