关于如何提取json信息的问题

假设tb = table(`1`2`3 as id , ['{"a",2,"b":3,"c":"val1"}','{"a",11,"b":32,"c":"val2"}','{"a",21,"b":30,"c":"val3"}']) 

如何高效的提取出a,b,c的值,并整理成table 


请先 登录 后评论

1 个回答

mhxiang
tb = table(`1`2`3 as id , ['{"a":2,"b":3,"c":"val1"}','{"a":11,"b":32,"c":"val2"}','{"a":21,"b":30,"c":"val3"}'] as val) 
def f(val){
	a=each(x->parseExpr(x).eval()["a"],val)
	b=each(x->parseExpr(x).eval()["b"],val)
	c=each(x->parseExpr(x).eval()["c"],val)
	return a,b,c
	}
select id,f(val) as `a`b`c from tb
请先 登录 后评论
  • 1 关注
  • 0 收藏,884 浏览
  • 韩先生 提出于 2022-07-05 10:24

相似问题