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