根据导出的位置不一样,将这些方式分为三种:
1、导出到本地文件系统;
2、导出到HDFS中;
3、导出到Hive的另一个表中。
一、导出到本地文件系统及HDFS中
INSERT OVERWRITE LOCAL DIRECTORY '/home/spark/opt/data_dir/base_food' row format delimited fields terminated by '|' SELECT a.* FROM base_food a;
hive> insert overwrite local directory '/home/spark/opt/data_dir/base_dh_stock'
> select * from base_dh_stock;
Time taken: 16.704 seconds
数据量:37857
hive>
> insert overwrite directory '/alidata/base_dh_stock'
> select * from base_dh_stock;
Time taken: 15.986 seconds
数据量:37857
hive> insert overwrite directory '/alidata/base_dh_stock'
> row format delimited
> fields terminated by '$'
> select * from base_dh_stock;
Time taken: 15.749 seconds
hive> insert overwrite local directory '/home/spark/