用hive 子查询语句 怎么将下面的拆解成key 和 value 两列 多行
{
"s2becb28":[{"key":"x59fa40c","value":"在岗"},{"key":"xb650e1e","value":"休息"}],
"n7b6d522":[{"key":"wd38fcc3","value":"在岗"},{"key":"h017afb7","value":"休息"}],
"z9ab4ba3":[{"key":"p8c1881e","value":"在岗"},{"key":"c1bbde95","value":"休息"}],
"w27b0c03":[{"key":"l8be1e84","value":"在岗"},{"key":"w838ca8e","value":"休息"}],
"fce40896":[{"key":"tb19a7a7","value":"在岗"},{"key":"h820a54a","value":"休息"}],
"y0ef63e5":[{"key":"lf576b13","value":"拣货员"},{"key":"i3e988bc","value":"配送员"}],
"n57ca4af":[{"key":"qfdd828d","value":"在岗"},{"key":"sf0615f3","value":"休息"}],
"q34460fe":[{"key":"r7be668a","value":"在岗"},{"key":"g133c912","value":"休息"}]
}