任务:INSERT_ADD_BD_DW_GENERAL_PUSH
脚本内容:
hive -v -e "use db_ecar;
set hive.map.aggr.hash.percentmemory = 0.25;
INSERT INTO TABLE BD_DW_GENERAL_PUSH
SELECT t4.USER_ID
,t1.TERMINAL_ID
,t4.OPEN_ID
,substr(t1.LASTUPDATE_TIME,1,10) AS TIME_ID
,t3.CHANNEL_TYPE AS PUSH_ID
,t1.CONTENT_TYPE AS CONTENT_ID
,sum(case when t1.flag in (1,2) then 1 else 0 end ) AS PU