Hi Peter,
Just to clarify... Internally, Drill stores numbers as FLOAT or DOUBLE. The
question is how a client displays the numbers. Khurram has listed a number of
those clients. If you are using a JDBC/ODBC client, then the issue might be in
the tool using that driver.
For Drill's own client tools, Drill does not support metadata, so there is no
way to express a preferred display format for your column. Instead, the
client's own display rules control display.
Thanks,
- Paul
On Tuesday, May 8, 2018, 11:04:13 AM PDT, Khurram Faraaz <[email protected]>
wrote:
Hi Peter,
Where do you see large numbers being represented/displayed as exponents, in
Drill (and what version of Drill are you on) ?
1. Do you see that behavior on sqlline prompt ?
2. Do you see it from a JDBC application ?
3. Do you see that on Drill's Web UI ?
4. If you don't see it on the three options above, where is it that you see
large numbers being represented as exponents ?
Your response to questions above will help us investigate.
Thanks,
Khurram
________________________________
From: Vova Vysotskyi <[email protected]>
Sent: Tuesday, May 8, 2018 8:44:46 AM
To: [email protected]
Subject: Re: Apache Drill Automatically Converts Large Numbers to Exponents
Hi Peter,
If the problem is only with displaying the numbers, you may convert it to
the string with the specified format using TO_CHAR(expression, format) UDF.
For more details please see
https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_data-2Dtype-2Dconversion_-23other-2Ddata-2Dtype-2Dconversions&d=DwIFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=H5JEl9vb-mBIjic10QAbDD2vkUUKAxjO6wZO322RtdI&m=Ie9zGKXICN7MzxqsC1pm2IVdufd_8Lh-QXKd_u6VU3Y&s=2f_ECxi0EnA5vpjDq7nGXG9YyswBfUp9QRt_tMO_64Q&e=
Kind regards,
Volodymyr Vysotskyi
вт, 8 трав. 2018 о 18:36 Peter Edike <[email protected]>
пише:
> Hello everyone,
>
> How can I prevent Apache Drill From Displaying large numers as exponents
> as this is not acceptable for my use case
>
>
> Kind regards
> Peter Edike
>
