Hi Paul, Thanks for all your inputs . Now I found the workaround if I cast the values I am able to read but unable to read when just pick the columns without casting. Is it the right way of doing it ? Is it the same case with users in the Drill Community ?
Thanks, Divya On 1 June 2018 at 02:11, Paul Rogers <[email protected]> wrote: > Hi Divya, > Please file a bug. Your file has a float, followed by an int. It is > entirely possible for Drill to read the int as a float. There is work in > progress that contains this fix, but would be good to file a bug (and get a > fix) even with the current reader. > > What Drill can't do is "predict the future": the following cannot work: > [10, 10.2]. > > Short-term fix: change the file so that the "11" is "11.0", etc. > > Thanks, > - Paul > > > > On Wednesday, May 30, 2018, 8:29:11 PM PDT, 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 > > >
