Hive导出数据的五种方式分别是什么？

1. Insert方式，查询结果导出到本地或HDFS

Insert overwrite local directory ‘/root/insert/student’ select id,name from student; Insert overwrite directory ‘/user/ insert /student’ select id,name from student;

  2. Hadoop命令导出本地

hive>dfs -get /user/hive/warehouse/student/ 000000_0 /root/hadoop/student.txt

  3. hive Shell命令导出

]$ bin/hive -e ‘select id,name from student;’ > /root/hadoop/student.txt

  4. Export导出到HDFS

hive> export table student to ‘/user/export/student’;

  5. Sqoop导出