Hi Drillers, I just wanted to understand what the expected behavior would be in the below scenario
My dataset :
1|{"a":"b"}{"a":"c"}
In the above dataset, I have 2 json records in the second column. However
the below query just returns the first record as the output
select convert_from(columns[1], 'JSON') from `convert.tbl`;
+------------+
| EXPR$0 |
+------------+
| {"a":"b"} |
+------------+
Should drill implicitly do a flatten sort of thing and return 2 rows, one
for each json record?
- Rahul
