核心内容摘要
《家访》续章:五一特别篇,娜娜老师镜头下的温情与成长
SELECT-- 成员iddistinct_idASmember_id,-- 浏览时长get_json_object(all_json,$.properties.event_duration)ASbrow_duration,-- 浏览退出时间from_unixtime(CAST(get_json_object(all_json,$.time)ASDOUBLE)/
SELECT-- 成员iddistinct_idASmember_id,-- 浏览时长get_json_object(all_json,$.properties.event_duration)ASbrow_duration,-- 浏览退出时间from_unixtime(CAST(get_json_object(all_json,$.time)ASDOUBLE)/