插入新的aladdin卡片

aladdin全量表 dm_autocar.autocar_search_aladdin_info_dim_v2

aladdin报表 aladdin维度表 dm_autocar.autocar_aladdin_dim

aladdin报表 任务 dm_autocar.autocar_dim_search_aladdin_info_daily

aladdin全量表插入新的aladdin卡片

insert overwrite table dm_autocar.autocar_search_aladdin_info_dim_v2
select 
    res_mode,
    aladdin,
    is_nature_result
from 
    dm_autocar.autocar_search_aladdin_info_dim_v2

union all 
select
    '178_outer_appearance' as res_mode,
    '外观' as aladdin,
    '0' as is_nature_result

union all 
select
    '176_koubei_all' as res_mode,
    '整体口碑' as aladdin,
    '0' as is_nature_result

union all 
select
    '176_koubei_tag' as res_mode,
    '定向口碑' as aladdin,
    '0' as is_nature_result

aladdin报表插入新的aladdin卡片

insert overwrite table dm_autocar.autocar_aladdin_dim
select 
    res_mode,
    aladdin
from 
    dm_autocar.autocar_aladdin_dim

union all 
select
    '178_outer_appearance' as res_mode,
    '外观' as aladdin

union all 
select
    '176_koubei_all' as res_mode,
    '整体口碑' as aladdin

union all 
select
    '176_koubei_tag' as res_mode,
    '定向口碑' as aladdin