hive json ( list (map) ½á¹¹ ) ת¶àÐÐ

json×ֶθñʽ { "a": { "10000": 11, "20000": 22 }, "b": { "10000": 14, "20000": 255 } } with q as ( select t.member_id, replace(t.prod_code, '"') as prod_c