队列名称

集群：hibis     队列：root.hibis_autocar.dev            上线500%   可设置优先级
集群：hl        队列：root.hl_autocar.dev               上线500%   可设置优先级
集群：lobst     队列：root.lobst_autocar_analysis       上线800%   可设置优先级
集群：default   队列：root.autocar.stats                上线500%   不可设置优先级

--优化数据，慎用排序，排序数据容易倾斜，特别慢

-- 车系页及下属页面停留时长
    select
        '${date}' as date,
        t_car_series.device_id,
        t_car_series.series_sub_stay_time / 60000 as series_sub_stay_time,
        t_distinct.os_name,
        t_distinct.is_new,
        t_distinct.channel
    from
    (
        select
            device_id,
            sum(params['stay_time']) as series_sub_stay_time
        from 
            dm_autocar.autocar_mds_event_detail
        where 
            date = '${date}'
            and event = 'stay_page_pageid'
            and 
            (
                params['page_id'] in ('page_car_series','page_car_series_atlas','page_more_config','page_series_owner_price','page_car_pk_list','page_series_atlas_3d_full_screen','page_series_pic_detail','page_series_pic_item_selected','anchor_list_page','page_series_video_detail','page_car_owner_price','page_car_owner_price_upload','page_brand_list_garage','page_series_pk','page_car_style_list','page_car_highlights_list','highlight_config_detail_page','page_car_style','page_car_dealer','page_order_specdealer','page_order_sugdealer')
                or (params['page_id'] = 'page_detail' and params['pre_page_id'] = 'page_car_series')
                or (params['page_id'] = 'page_ugc_video_detail' and params['pre_page_id'] = 'page_car_series')
                or (params['page_id'] = 'page_car_talk_main' and params['pre_page_id'] = 'page_car_series')
                or (params['page_id'] = 'page_reputation_detail' and params['pre_page_id'] = 'page_car_series')
            )
        group by device_id
    )t_car_series

    inner join
    (
        select
            cast(device_id as string) as device_id,
            nvl(os,'其他') as os_name,
            if(activation_date = '${DATE}',1,0) as is_new,
            nvl(channel_account_subclass,'其他') as channel
        from
        (
            select
                device_id,
                os,
                activation_date,
                channel
            from
                dm_autocar.autocar_mds_user_by_device_distinct
            where
                date = '${date}'
                and is_background = 0
        )t_distinct_dau

        left outer join 
        (
            select
                channel_name,
                channel_account_subclass
            from
                growth.o_pgl_channel_all  
            where
                date = '${date}'
                and app_name = 'automobile'
            group by
                channel_name,
                channel_account_subclass
        )t_channel
        on t_distinct_dau.channel = t_channel.channel_name
    )t_distinct
    on t_car_series.device_id = t_distinct.device_id
    where  channel = '内部互推'
    -- order by series_sub_stay_time desc limit 1000000000