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
