Andries, But if you set Excel to use , as the decimal separator, then 925.0000 could be displayed as 925,0000
Guessing by name, I suspect that Paolo is European and might have Excel set this way. On Fri, Jan 22, 2016 at 9:26 AM, Andries Engelbrecht < [email protected]> wrote: > 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 > >> > >
