-- 探索 loghubods.dwd_recsys_alg_sample_all_20250212 表
-- 查看样本数据和模型分数字段

SELECT  dt
        ,hh
        ,vid
        ,apptype
        ,page
        ,abcode
        ,is_share
        ,share_cnt
        ,is_return_1
        ,is_return_n
        ,is_return_noself
        ,return_1_uv
        ,return_n_uv
        ,return_n_uv_noself
        ,new_exposure_cnt
        ,score
        ,REPLACE(GET_JSON_OBJECT(extend_alg,'$.scoresMap'),'\\','') AS scoresmap
FROM    loghubods.dwd_recsys_alg_sample_all_20250212
WHERE   dt = '${dt}'
AND     hh = '10'
AND     apptype = 'zuiyou'
AND     extend_alg IS NOT NULL
LIMIT   20
;
