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

时间：2024-07-01 21:07:18

数据湖探索 DLI

将SELECT查询结果插入到表中

    
         INSERT INTO [TABLE] [db_name.]table_name
  [PARTITION part_spec] select_statement;

    
         INSERT OVERWRITE TABLE [db_name.]table_name
  [PARTITION part_spec] select_statement;

part_spec:  
  : (part_col_name1=val1 [, part_col_name2=val2, ...])

将某条数据插入到表中

    
         INSERT INTO [TABLE] [db_name.]table_name
  [PARTITION part_spec] VALUES values_row [, values_row ...];

    
         INSERT OVERWRITE TABLE [db_name.]table_name
  [PARTITION part_spec] VALUES values_row [, values_row ...];

values_row:
  : (val1 [, val2, ...])

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

意见反馈

0/200

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

7*24