Hive导出数据有几种方式？

1、用insert overwrite导出方式

导出到本地： insert overwrite local directory ‘/home/robot/1/2’ rom format delimited fields terminated by ‘\t’ select * from staff;(递归创建目录) 导出到HDFS insert overwrite directory ‘/user/hive/1/2’ rom format delimited fields terminated by ‘\t’ select * from staff;

2、Bash shell覆盖追加导出

例如：$ bin/hive -e “select * from staff;” > /home/z/backup.log

3、Sqoop把hive数据导出到外部