I have a Json array
<code>{ "foo": [ { "a": "bar", "b": 10, "c": 100 } ] }
</code>
<code>{ "foo": [ { "a": "bar", "b": 10, "c": 100 } ] }
</code>
{ "foo": [ { "a": "bar", "b": 10, "c": 100 } ] }
How to convert it to an array of tuples?
<code>Array(Tuple(String, Int64))
</code>
<code>Array(Tuple(String, Int64))
</code>
Array(Tuple(String, Int64))
where String is a and Int64 is b?
1
<code>SELECT JSONExtract('[{"a":"bar","b":10, "c":100}]', 'Array(Tuple(String, Int64))')
┌─JSONExtract('[{"a":"bar","b":10, "c":100}]', 'Array(Tuple(String, Int64))')─┐
1. │ [('bar',10)] │
└─────────────────────────────────────────────────────────────────────────────┘
1 row in set. Elapsed: 0.005 sec.
</code>
<code>SELECT JSONExtract('[{"a":"bar","b":10, "c":100}]', 'Array(Tuple(String, Int64))')
┌─JSONExtract('[{"a":"bar","b":10, "c":100}]', 'Array(Tuple(String, Int64))')─┐
1. │ [('bar',10)] │
└─────────────────────────────────────────────────────────────────────────────┘
1 row in set. Elapsed: 0.005 sec.
</code>
SELECT JSONExtract('[{"a":"bar","b":10, "c":100}]', 'Array(Tuple(String, Int64))')
┌─JSONExtract('[{"a":"bar","b":10, "c":100}]', 'Array(Tuple(String, Int64))')─┐
1. │ [('bar',10)] │
└─────────────────────────────────────────────────────────────────────────────┘
1 row in set. Elapsed: 0.005 sec.