I have a field that is mostly absent from most of my JSON records, but when it appears it is a string. Drill does not like this. It seems if the first value is 4k+ records into a file it is treated as an INT. I've tried casting and using case statements, but I cannot seem to find a work around. Currently, running 1.4. Is there a workaround?
org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: Error parsing JSON - You tried to write a VarChar type when you are using a ValueWriter of type NullableIntWriterImpl. File /events/2016/02/18/04/sp-firehose-event-stream-1-2016-02-18-04-05-36-2b359c8d-926f-46c8-aead-a85d2a1cb9a1.json Record 6210 Fragment 0:0 [Error Id: d75b9c2c-eeeb-498d-995a-fcfad8d72991 on ip-172-31-43-83.ec2.internal:31010]
