hive的inseet导出

将a表的数据导出到b表中

insert into b select  * from a; 

将表数据导出到文件夹中

 -- 将查询的结果保存在文件夹中
insert overwrite local directory '/data/output'
select * from tb_orders;

导出的数据默认使用隐藏分隔符 , 可以自己指定数据属性的分隔符

insert overwrite local directory '/data/output2'
row format delimited fields terminated by ',' 
select * from tb_orders;

insert overwrite local directory '/data/output3'
row format delimited fields terminated by '-' 
select * from tb_orders;

可以将数据导出到HDFS上

insert overwrite  directory '/data/output3'
row format delimited fields terminated by '-' 
select * from tb_orders;