hive数据导入导出

drop table XXX;
create table XXX(
    .....
)partitioned by(dt string)
row format delimited fields
terminated by '\t';

load DATA LOCAL inpath 'test' overwrite into TABLE XXX partition(dt='20200417');

insert overwrite local directory '/usr/home/XXX'
row format delimited
fields terminated by ','
select 
.....