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
