MAPREDUCE服务 MRS-INSERT INTO:示例

时间：2024-05-30 16:45:26

MAPREDUCE服务 MRS

示例

insert into h0 select 1, 'a1', 20;

-- insert static partition
insert into h_p0 partition(dt = '2021-01-02') select 1, 'a1';

-- insert dynamic partition
insert into h_p0 select 1, 'a1', dt;

-- insert dynamic partition
insert into h_p1 select 1 as id, 'a1', '2021-01-03' as dt, '19' as hh;

-- insert overwrite table
insert overwrite table h0 select 1, 'a1', 20;

-- insert overwrite table with static partition
insert overwrite h_p0 partition(dt = '2021-01-02') select 1, 'a1';

-- insert overwrite table with dynamic partition
insert overwrite table h_p1 select 2 as id, 'a2', '2021-01-03' as dt, '19' as hh;

上一篇：MAPREDUCE服务 MRS-INSERT INTO:注意事项

下一篇：MAPREDUCE服务 MRS-INSERT INTO:注意事项