What does the JSON data look like?
I did a quick test with Excel and MS Query through ODBC to connect to Drill.
Selecting data as either a string or numeric value.
select * from (values('925.000',925.0000))
The results returned is
925.000 for the string value and 925 for the numeric value to Excel.
With Drill 1.4 you can use typeof() to see what data type it being interpreted
as.
--Andries
> On Jan 22, 2016, at 8:50 AM, Ted Dunning <[email protected]> wrote:
>
> This sounds like this might be a problem of decimal point separator. Can
> you say what decimal point character you normally use? It might also be
> that this is set differently on the exel machine from the machine where
> drill is running.
>
> I am presuming that the value that you want to see is 925.0
>
> Is that correct?
>
>
> On Fri, Jan 22, 2016 at 6:33 AM, Paolo Spanevello <[email protected]>
> wrote:
>
>> Dear All,
>> i'm drilling a JSON File with some fields with numbers with this format :
>>
>> 1s_critical_power
>> 925.00000
>>
>>
>> I'm using ODBC Driver to connect it on excel and the result aspect is
>>
>> 1s_critical_power
>> 925,00000
>> Do you know the right way to have it?
>>
>> Best regards,
>> Paolo
>>
