数据导出
文章目录
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操作