kudu表数据的导入导出

create table default.kudu_table(
aid string not null,
ts bigint,
count bigint,
primary key(aid)
)
PARTITION BY HASH (aid) PARTITIONS 6 STORED AS KUDU;

insert into default.kudu_table values (“1”, 11, 11), (“2”, 22, 22)

impala-shell -q “select * from default.kudu_table” -B --output_delimiter="*" -o /data/tmp/test.csv

create table default.kudu_table2(
aid string,
ts bigint,
count bigint)row format delimited fields terminated by ‘*’;

load data local inpath ‘/data/tmp/test.csv’ into table default.kudu_table2;

create table default.kudu_table3(
aid string not null,
ts bigint,
count bigint,
primary key(aid)
)
PARTITION BY HASH (aid) PARTITIONS 6 STORED AS KUDU;

insert into default.kudu_table3 select * from default.kudu_table2;