Hive 导出数据按逗号分隔_hive数据用逗号分隔

作者：小丑西瓜9 | 2024-05-18 21:54:10

踩

hive数据用逗号分隔

1、若数据文件格式恰好是用户需要的格式，只需简单的使用hdfs 命令copy即可

hadoop fs - cp source_path target_path

2 、使用 INSERT .... DIRECTORY.... ,如下面例子所示:

INSERT OVERWRITE LOCAL DIRECTORY '/home/hadoop/stu'

SELECT ID,NAME,AGE FROM T2;

下面我们将导出的数据按行以逗号进行分隔.

insert overwrite local directory '/home/hadoop/stu'
row format delimited fields terminated by ','
select * from t2;


hive> insert overwrite local directory  '/home/hadoop/stu'
    > row format delimited fields terminated by ','
    > select * from t2;
WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future 
versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X 
releases.
Query ID = hadoop_20180830160049_43013e20-882f-4d75-9327-2611e9789bfe

查看导出的结果:

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小丑西瓜9/article/detail/590056