drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Divya Gehlot <divya.htco...@gmail.com>
Subject Re: Read complex json file gives list type doesn't support different data types
Date Fri, 01 Jun 2018 05:17:09 GMT
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 <par0328@yahoo.com.invalid> 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 <
> ppenumarthy@mapr.com> 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 <divya.htconex@gmail.com>
> 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
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message