1.将查询的结果导出到本地
insert overwrite local directory '本地路径' select 指定字段 from 表名;
2.将查询的结果格式化导出到本地
insert overwrite local directory '/export/servers/exporthive' row format delimited fields terminated by '\t' collection items terminated by '#' select * from student;
3.将查询的结果导出到HDFS上
insert overwrite directory '/export/servers/exporthive/a' select * from score;
4.Hadoop命令导出到本地
dfs -get /export/servers/exporthive/000000_0 /export/servers/exporthive/local.txt;
dfs -get 表中数据在HDFS上的存储位置 本地路径;
5.hive shell 命令导出到本地
hive -e "select * from myhive.score;" > /export/servers/exporthive/score.txt
hive -e "select 指定字段 from 表名;" > 本地路径;
6.export导出到HDFS上
export table score to '/export/exporthive/score';
export table 表名 to '本地路径';
7.通过sqoop方式导出