假设table格式如下:
现需要从val1中提取a下面的值,select parseExpr(val1).eval()['a'] from tb 报错,请问应该怎么实现类似于Mysql中的json_extract()函数的功能?
tb=table(1..3 as id ,[' {"a":1,"b":2}',' {"a":3,"b":4}','{"a":0,"b":2}'] as val1) select id,each(x->parseExpr(x).eval()["a"],val1) as a from tb