SELECT
name ,num
from table_name
LATERAL view explode(split(replace(replace(REPLACE(column,'[',''),']',''),"),[",");("),";"))
t as table_column
lateral view json_tuple(table_column, "name" ,"num")
t1 as name,num
SELECT
name ,num
from table_name
LATERAL view explode(split(replace(replace(REPLACE(column,'[',''),']',''),"),[",");("),";"))
t as table_column
lateral view json_tuple(table_column, "name" ,"num")
t1 as name,num