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 ---------------------------------------------------------------------------------------