Looks like the JSON has some schema changes across records. Turning on JSON all text mode should help.
set `store.json.all_text_mode` = true; Refer to https://drill.apache.org/docs/json-data-model/#data-type-mapping -Abhishek On Sat, Apr 30, 2016 at 12:10 PM, Paolo Spanevello <[email protected]> wrote: > Dear All, > i'm trying to open the file in attach with "Drill Explorer" but i have > this error back. > > The file is quite simple. > > Could you please support me? > Best regards, > Paolo > > > ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: > SELECT * FROM `Performance_Ride_Analytics`.`GC`.`./prova.json` LIMIT 100 > [30027]Query execution error. Details:[ > DATA_READ ERROR: You tried to write a Float8 type when you are using a > ValueWriter of type NullableBigIntWriterImpl. > > File /Users/****/AppData/Local/GoldenCheetah/prova.json > Record 1 > Line 19 > Column 33 > Field KM > Fragment 0:0 > > [Error Id: c73ab722-993d-4aa3-b8c8-30cfda921246 on****] >
