1、用insert overwrite导出方式
    导出到本地：
    insert overwrite local directory ‘/home/k6k4/user’ row format delimited fields terminated by ‘\t’ select * from user;(递归创建目录)
    导出到HDFS
    insert overwrite directory ‘/user/hive/user’ row format delimited fields terminated by ‘\t’ select * from user;

2、Bash shell覆盖追加导出
例如：$ bin/hive -e “select * from user;” > /home/k6k4/user.txt

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