Re: Error Open Json File with SELECT * FROM LIMIT 100

[Abhishek Girish <ab...@gmail.com>]

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 <pa...@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****]
>

Re: Error Open Json File with SELECT * FROM LIMIT 100

[Abhishek Girish <ab...@gmail.com>]

Hello Paolo,

I realized you are accessing the file via Drill Explorer. I tried accessing
the sample data you shared via Sqlline and it worked. The "set" command
only sets the option for that session. I'm not sure if there is a way to
set session options in Drill Explorer. You could try setting it at system
level and check if it works.

alter system set `store.json.all_text_mode` = true;

Regards,
Abhishek


On Sun, May 1, 2016 at 6:07 AM, Paolo Spanevello <pa...@gmail.com>
wrote:

> Dear Abhishek,
>
> I applied your workaround but the issue still exits .
>
> Any idea?
>
> best,
> Paolo
>

Re: Error Open Json File with SELECT * FROM LIMIT 100

[Paolo Spanevello <pa...@gmail.com>]

Dear Abhishek,

I applied your workaround but the issue still exits .

Any idea?

best,
Paolo