Can you please try to set this config parameter from sqlline and then run
your query.

alter session set `store.json.all_text_mode` = true;



On Wed, Oct 12, 2016 at 8:38 PM, Dan Blondowski <
dan.blondow...@dhigroupinc.com> wrote:

> Sorry!
> Select * from s3.`test.json`;
>
> Daniel Blondowski
>
> Big Data Architecture/Engineering
> DHI Group, Inc.
>
> dan.blondow...@dice.com
> 515-313-2137
>
>
>
>
>
> On 10/12/16, 9:52 AM, "Khurram Faraaz" <kfar...@maprtech.com> wrote:
>
> >Can you please share your SQL query ?
> >
> >On Wed, Oct 12, 2016 at 7:38 PM, Dan Blondowski <
> >dan.blondow...@dhigroupinc.com> wrote:
> >
> >> Hello.
> >>
> >> I have a json file with 2 records (see attached).
> >>
> >> When I run a query against it I get this error:
> >>
> >> *Error: DATA_READ ERROR: Error parsing JSON - You tried to write a
> >>BigInt
> >> type when you are using a ValueWriter of type
> >>NullableVarCharWriterImpl.*
> >>
> >>
> >> *File  /test.json*
> >>
> >> *Record  2*
> >>
> >> *Fragment 0:0*
> >>
> >>
> >> *[Error Id: 8b5166cc-28b6-488c-893f-f0265d483e13 on
> >>ip-10-3-48-183:31010]
> >> (state=,code=0)*
> >>
> >> If I break it up into individual files, I can run the query against both
> >> records just fine. Any clues?
> >>
> >> Thanks!
> >>
> >> Daniel Blondowski
> >>
> >> Big Data Architecture/Engineering
> >> DHI Group, Inc.
> >>
> >> dan.blondow...@dice.com
> >> 515-313-2137
> >>
> >>
> >> ------------------------------
> >> This email has been scanned for email related threats by Mimecast
> >> <http://www.mimecast.com>
> >> ------------------------------
> >>
> ------------------------------------------------------------
> ---------------------------
>  This email has been scanned for email related threats and delivered
> safely by Mimecast.
>  For more information please visit http://www.mimecast.com
> ------------------------------------------------------------
> ---------------------------
>

Reply via email to