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 <paolospane@gmail.com>
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****]
>
|