Hive---数据导出

数据导出

---

Insert 导出

表为student

将查询的结果导出到本地

insert overwrite local directory '/opt/hivedata/student' select * from student;

将查询的结果格式化导出到本地

insert overwrite local directory '/opt/hivedata/student' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' select * from student

将查询的结果导出到 HDFS 上

 insert overwrite directory '/tmp/hivedata/student' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' select * from student;

Hadoop 命令导出到本地

dfs -get /opt/hive/warehouse/student/student.txt /opt/hivedata/student2.txt;

Hive Shell 命令导出

基本语法：（hive -f/-e 执行语句或者脚本 > file）

bin/hive -e ‘select * from default.student;’ > /opt/hivedata/student3.txt;

Export 导出到 HDFS 上

export table default.student to '/opt/hive/warehouse/export/student';

sqoop导出

详情请看
链接: Hive—sqoop安装教程及sqoop操作