drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Girish <abhishek.gir...@gmail.com>
Subject Re: Error Open Json File with SELECT * FROM <File> LIMIT 100
Date Sun, 01 May 2016 00:08:31 GMT
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****]
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message