-- 探索 loghubods.dwd_recsys_alg_sample_all_20250212 表
-- 不限制 hh，查看所有小时的数据

SELECT  dt
        ,hh
        ,vid
        ,apptype
        ,page
        ,is_share
        ,score
        ,SUBSTR(REPLACE(GET_JSON_OBJECT(extend_alg,'$.scoresMap'),'\\',''), 1, 200) AS scoresmap_preview
FROM    loghubods.dwd_recsys_alg_sample_all_20250212
WHERE   dt = '${dt}'
AND     apptype = 'zuiyou'
AND     extend_alg IS NOT NULL
LIMIT   10
;
