INSERT OVERWRITE TABLE sec_strategy_tech.underage_data_base_label PARTITION (dt)
with t1 as (
select
percentile_approx(harass_max, 0.5) AS harass_max_50th_percentile,
percentile_approx(harass_max, 0.6) AS harass_max_60th_percentile,
percentile_approx(harass_max, 0.7) AS harass_max_70th_percentile,
percentile_approx(harass_max, 0.8) AS harass_max_80th_percentile,
percentile_approx(harass_max, 0.85) AS harass_max_85th_percentile,
percentile_approx(harass_max, 0.9) AS harass_max_90th_percentile,
percentile_approx(harass_max, 0.95) AS harass_max_95th_percentile
from dd_sec_app.dm_all_trd_order_label_di
where dt between '2025-05-19' and '2025-06-02'
and expert_work = 1
and is_minor_expert in (0,1)
)
select
a.dt,sec_gen_id,CONCAT_WS(',', COLLECT_LIST(business_line)) AS business_line,
max(is_minor_expert) as is_minor_expert,
max(vulnerable_feature_harass_max_50th) as vulnerable_feature_harass_max_50th,
max(vulnerable_feature_harass_max_60th) as vulnerable_feature_harass_max_60th,
max(vulnerable_feature_harass_max_70th) as vulnerable_feature_harass_max_70th,
max(vulnerable_feature_harass_max_80th) as vulnerable_feature_harass_max_80th,
max(vulnerable_feature_harass_max_85th) as vulnerable_feature_harass_max_85th,
max(vulnerable_feature_harass_max_90th) as vulnerable_feature_harass_max_90th,
max(vulnerable_feature_harass_max_95th) as vulnerable_feature_harass_max_95th
from(
SELECT
x1.dt,
x1.passenger_id,
x1.business_line,
MAX(is_minor_expert) AS is_minor_expert,
MAX(IF(
(sexual_harassment = 1 AND ask_for_contact = 0)
OR (sensitive_conflict = 1 AND ask_for_contact = 0)
OR (harass_max > (SELECT harass_max_50th_percentile FROM t1 ))
OR (l4d_flag = 1), 1, 0
)) AS vulnerable_feature_harass_max_50th,
MAX(IF(
(sexual_harassment = 1 AND ask_for_contact = 0)
OR (sensitive_conflict = 1 AND ask_for_contact = 0)
OR (harass_max > (SELECT harass_max_60th_percentile FROM t1 ))
OR (l4d_flag = 1), 1, 0
)) AS vulnerable_feature_harass_max_60th,
MAX(IF(
(sexual_harassment = 1 AND ask_for_contact = 0)
OR (sensitive_conflict = 1 AND ask_for_contact = 0)
OR (harass_max > (SELECT harass_max_70th_percentile FROM t1 ))
OR (l4d_flag = 1), 1, 0
)) AS vulnerable_feature_harass_max_70th,
MAX(IF(
(sexual_harassment = 1 AND ask_for_contact = 0)
OR (sensitive_conflict = 1 AND ask_for_contact = 0)
OR (harass_max > (SELECT harass_max_80th_percentile FROM t1 ))
OR (l4d_flag = 1), 1, 0
)) AS vulnerable_feature_harass_max_80th,
MAX(IF(
(sexual_harassment = 1 AND ask_for_contact = 0)
OR (sensitive_conflict = 1 AND ask_for_contact = 0)
OR (harass_max > (SELECT harass_max_85th_percentile FROM t1 ))
OR (l4d_flag = 1), 1, 0
)) AS vulnerable_feature_harass_max_85th,
MAX(IF(
(sexual_harassment = 1 AND ask_for_contact = 0)
OR (sensitive_conflict = 1 AND ask_for_contact = 0)
OR (harass_max > (SELECT harass_max_90th_percentile FROM t1 ))
OR (l4d_flag = 1), 1, 0
)) AS vulnerable_feature_harass_max_90th,
MAX(IF(
(sexual_harassment = 1 AND ask_for_contact = 0)
OR (sensitive_conflict = 1 AND ask_for_contact = 0)
OR (harass_max > (SELECT harass_max_95th_percentile FROM t1 ))
OR (l4d_flag = 1), 1, 0
)) AS vulnerable_feature_harass_max_95th
FROM dd_sec_app.dm_all_trd_order_label_di x1
WHERE x1.dt BETWEEN '2025-06-03' AND '2025-08-17'
AND expert_work = 1
AND is_minor_expert IN (0,1)
GROUP BY x1.dt, x1.passenger_id,x1.business_line
)a
left join(
select passenger_id as pas_id,sec_gen_id
from dd_sec_dw.dim_netcar_sec_pas_pid_sum_df
where dt = '2025-08-17'
group by passenger_id,sec_gen_id
)b
on a.passenger_id = b.pas_id
group by dt,sec_gen_id
DriverContainer URL: http://bigdata-nmg-hdp3660.nmg01.diditaxi.com.bigdata.intra.xiaojukeji.com:8042/node/containerlogs/container_e33_1742893081520_72283671_01_000001/prod_sec_strategy_tech
Error in query:
mismatched input 'with' expecting {'(', 'FROM', 'MAP', 'REDUCE', 'SELECT', 'TABLE', 'VALUES'}(line 4, pos 0)
== SQL ==
在上海，几位女性通过举起“我可以骚，你不能扰”的标语，抗议了地铁官方关于“衣着暴露的女性容易遭受性骚扰”的不当言论。她们认为女性有权自由选择自己的着装，并强调不应将着装作为性骚扰的借口。
扫一扫
40
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
