You'll need to add a comma if you want to do this as [ {}{} ] is not
valid. Only [ {}, {} ] is.
On Wed, Nov 19, 2014 at 12:48 PM, Tomer Shiran <[email protected]> wrote:
> If you wrap the two maps in an array [{...}{...}] then the convert should
> work and you can decide whether to use the new flatten function to get two
> separate top level records.
>
>
>
> > On Nov 20, 2014, at 5:50 AM, rahul challapalli <
> [email protected]> wrote:
> >
> > 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
>
