-- Neo4j User 节点属性补充
-- 用于导入后按需补充用户详情
-- 使用 run_sql.py 执行（无日期分区）

SELECT
    uid,
    mid,
    nick_name,
    gender,
    country,
    province,
    city,
    gmt_create_timestamp as register_ts
FROM videoods.dim_user
LATERAL VIEW explode(split(mids, ',')) t AS mid
WHERE mids IS NOT NULL AND mids != ''
