Actually, you want to enable all-text mode. Unions won't help as you'd need a
union in a list (Drill's repeated list type) which, frankly, does not yet work.
With all-text mode, you'd need to do the conversion, which is awkward for
lists...
Thanks,
- Paul
On Thursday, May 31, 2018, 2:23:25 AM PDT, Divya Gehlot
<[email protected]> wrote:
I tried exec.enable_union_type it didnt work for me ,however below helped :
ALTER SESSION SET `store.json.read_numbers_as_double` = true;
On 31 May 2018 at 11:28, Padma Penumarthy <[email protected]> wrote:
> yes, that is correct.
> You can try setting the option “exec.enable_union_type” for that to work
> with the caveat that
> union type is not fully supported in drill.
>
> Thanks
> Padma
>
>
> > On May 30, 2018, at 7:56 PM, Divya Gehlot <[email protected]>
> wrote:
> >
> > Hi,
> > I am reading a complex json file, I am getting format doesn't support
> while
> > reading below :
> > "Coordinates":[
> > [
> > 23.53,
> > 4.99,
> > 11
> > ],
> > [
> > 35.09,
> > 7.7,
> > 16
> > ]
> > ]
> >
> >
> > Error : Query execution error. Details:[
> >> UNSUPPORTED_OPERATION ERROR: In a list of type FLOAT8, encountered a
> value
> >> of type BIGINT. Drill does not support lists of different types.
> >> Line 15
> >> Column 19
> >> Field Coordinates
> >> Line 15
> >> Column 19
> >> Field Coordinates
> >> Line 15
> >> Column 19
> >> Field Coordinates
> >> Fragment 0:0
> >
> >
> > If I remove the third coordinates(11,16) which is integer it works like
> > charm .
> >
> > Does that means Drill doesn't support values of different data types in
> > array list?
> >
> > Appreciate the help !
> >
> > Thanks,
> > Divya
>
>
