数据湖探索 DLI-插入数据至DWS表:语法格式

时间:2024-11-11 14:11:00

语法格式

  • 将SELECT查询结果插入到表中:
    1
    2
    3
    4
    5
    6
    7
    INSERT INTO  DLI _TABLE
      SELECT field1,field2...
      [FROM DLI_TEST]
      [WHERE where_condition]
      [LIMIT num]
      [GROUP BY field]
      [ORDER BY field] ...;
    
  • 将某条数据插入到表中:
    1
    2
    INSERT INTO DLI_TABLE
      VALUES values_row [, values_row ...];
    
support.huaweicloud.com/sqlref-spark-dli/dli_08_0194.html