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 > >
