当前位置:   article > 正文

Hive 2.3.3 是默认支持insert overwrite、insert into的,不需要修改配置文件_insert into overwrite clickhouse

insert into overwrite clickhouse

在Hive 2.3.3版本中使用insert overwrite、insert into可以实现向表中插入数据的功能,并且不需要修改配置文件,是默认支持的。看我写的hql:

insert overwrite table subscribe_log_info (
(select t1.userid,t1.newfan,t1.clfan,t1.clefan,t1.allfan+t2.allfan from cleaned_subscribe_log_info_bak t1,t_news_fan_analysis_day t2 where t1.userid = t2.userid)
union all
(select t1.* from cleaned_subscribe_log_info_bak t1 left outer join t_news_fan_analysis_day t2 on t1.userid = t2.userid where t2.userid is null));

insert into table subscribe_log_info
select t1.userid,t1.allfan+t2.allfan from subscribe_log_info t1,t_news_fan_analysis_day t2 where t1.userid = t2.userid;

声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:【wpsshop博客】
推荐阅读
相关标签
  

闽ICP备14008679号