当前位置:首页 > 开发 > 系统架构 > 架构 > 正文

hive查询导出到hdfs,hive,file

发表于: 2014-10-28   作者:blackproof   来源:转载   浏览:
摘要: INSERT OVERWRITE LOCAL DIRECTORY '/script/dirk.zhang/test' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' select... ...;     insert overwrite [local] directory '/data/movielens/100k/output/

INSERT OVERWRITE LOCAL DIRECTORY '/script/dirk.zhang/test' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' select... ...;  

 

insert overwrite [local] directory '/data/movielens/100k/output/item_release_date_10' select release_date from item limit 10;

 

insert overwrite table data2 partition(dt='1997-12') select * from data where from_unixtime(timestamp, 'yyyy-MM') = '1997-12';

 

导入到hive

load data local inpath '${OUTPUT}/hive_subscribe_biz.*.${FILE_DATE}' overwrite into table subscribe_biz partition(logday='$LOG_DATE');

 

load data inpath '${hive_path2}/part*'  overwrite into table orig_subscribe_monitor_company partition(logday='$LOG_DATE');

hive查询导出到hdfs,hive,file

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号