表为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
insert overwrite directory '/tmp/hivedata/student' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' select * from student;
dfs -get /opt/hive/warehouse/student/student.txt /opt/hivedata/student2.txt;
基本语法:(hive -f/-e 执行语句或者脚本 > file)
bin/hive -e ‘select * from default.student;’ > /opt/hivedata/student3.txt;
export table default.student to '/opt/hive/warehouse/export/student';
详情请看
链接: Hive—sqoop安装教程及sqoop操作
上一篇:安装sqoop