dwd_user_register_inc="
insert overwrite table ${APP}.dwd_user_register_inc partition(dt='$do_date')
select
ui.user_id,
date_format(create_time,'yyyy-MM-dd') date_id,
create_time,
channel,
province_id,
version_code,
mid_id,
brand,
model,
operate_system
from
(
select
data.id user_id,
data.create_time
from ${APP}.ods_user_info_inc
where dt='$do_date'
and type='insert'
)ui
left join
(
select
common.ar area_code,
common.ba brand,
common.ch channel,
common.md model,
common.mid mid_id,
common.os operate_system,
common.uid user_id,
common.vc version_code
from ${APP}.ods_log_inc
where dt='$do_date'
and page.page_id='register'
and common.uid is not null
)log
on ui.user_id=log.user_id
left join
(
select
id province_id,
area_code
from ${APP}.ods_base_province_full
where dt='$do_date'
)bp
on log.area_code=bp.area_code;
"
case $1 in
"dwd_interaction_comment_inc" )
hive -e "$dwd_interaction_comment_inc"
;;
"dwd_interaction_favor_add_inc" )
hive -e "$dwd_interaction_favor_add_inc"
;;
"dwd_tool_coupon_get_inc" )
hive -e "$dwd_tool_coupon_get_inc"
;;
"dwd_tool_coupon_order_inc" )
hive -e "$dwd_tool_coupon_order_inc"
;;
"dwd_tool_coupon_pay_inc" )
hive -e "$dwd_tool_coupon_pay_inc"
;;
"dwd_trade_cancel_detail_inc" )
hive -e "$dwd_trade_cancel_detail_inc"
;;
"dwd_trade_cart_add_inc" )
hive -e "$dwd_trade_cart_add_inc"
;;
"dwd_trade_cart_full" )
hive -e "$dwd_trade_cart_full"
;;
"dwd_trade_order_detail_inc" )
hive -e "$dwd_trade_order_detail_inc"
;;
"dwd_trade_order_refund_inc" )
hive -e "$dwd_trade_order_refund_inc"
;;
"dwd_trade_pay_detail_suc_inc" )
hive -e "$dwd_trade_pay_detail_suc_inc"
;;
"dwd_trade_refund_pay_suc_inc" )
hive -e "$dwd_trade_refund_pay_suc_inc"
;;
"dwd_traffic_action_inc" )
hive -e "$dwd_traffic_action_inc"
;;
"dwd_traffic_display_inc" )
hive -e "$dwd_traffic_display_inc"
;;
"dwd_traffic_error_inc" )
hive -e "$dwd_traffic_error_inc"
;;
"dwd_traffic_page_view_inc" )
hive -e "$dwd_traffic_page_view_inc"
;;
"dwd_traffic_start_inc" )
hive -e "$dwd_traffic_start_inc"
;;
"dwd_user_login_inc" )
hive -e "$dwd_user_login_inc"
;;
"dwd_user_register_inc" )
hive -e "$dwd_user_register_inc"
;;
"all" )
hive -e "$dwd_interaction_comment_inc$dwd_interaction_favor_add_inc$dwd_tool_coupon_get_inc$dwd_tool_coupon_order_inc$dwd_tool_coupon_pay_inc$dwd_trade_cancel_detail_inc$dwd_trade_cart_add_inc$dwd_trade_cart_full$dwd_trade_order_detail_inc$dwd_trade_order_refund_inc$dwd_trade_pay_detail_suc_inc$dwd_trade_refund_pay_suc_inc$dwd_traffic_action_inc$dwd_traffic_display_inc$dwd_traffic_error_inc$dwd_traffic_page_view_inc$dwd_traffic_start_inc$dwd_user_login_inc$dwd_user_register_inc"
esac
dsti提交的任务在yarn上执行
最新推荐文章于 2024-09-12 12:42:46 发布