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 >
