Unfortunately, the only information shared is the file name and the record having the issue. In your example, you can see that the issue was with record 2 in file /test.json. You will need to use trial and error method to isolate the field in my opinion.
On Wed, Oct 12, 2016 at 9:01 AM, Dan Blondowski <dan.blondowski@dhigroupinc. com> wrote: > Hello. You were correct. > I was able to set `store.json.all_text_mode` = true; and run the query. > > I also found the data that needed changing. There were actually 3 fields. > > Is there a way for Drill to display which field is bad, so I don¹t have to > do the trial & error? > > > > > On 10/12/16, 10:12 AM, "Abhishek Girish" <[email protected]> > wrote: > > >Hey Dan, > > > >This usually happens when there is a schema change across records. It > >could > >be intentional (records do need different types for some fields) or bad > >formatting (1 vs "1"). > > > >Can you try setting this session option and retry your query? Let us know > >if it helps. You could attempt to use explicit casts in the query to get > >types you want. > > > > set `store.json.all_text_mode` = true; > > > >Regards, > >Abhishek > > > >On Wednesday, October 12, 2016, 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] > >> <javascript:_e(%7B%7D,'cvml','[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 > ------------------------------------------------------------ > --------------------------- >
