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 < [email protected]> wrote: > Sorry! > Select * from s3.`test.json`; > > Daniel Blondowski > > Big Data Architecture/Engineering > DHI Group, Inc. > > [email protected] > 515-313-2137 > > > > > > On 10/12/16, 9:52 AM, "Khurram Faraaz" <[email protected]> wrote: > > >Can you please share your SQL query ? > > > >On Wed, Oct 12, 2016 at 7:38 PM, Dan Blondowski < > >[email protected]> 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. > >> > >> [email protected] > >> 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 > ------------------------------------------------------------ > --------------------------- >
