You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Peter Edike <pe...@interswitchgroup.com> on 2018/05/08 15:36:26 UTC

Apache Drill Automatically Converts Large Numbers to Exponents

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

Re: Apache Drill Automatically Converts Large Numbers to Exponents

Posted by Paul Rogers <pa...@yahoo.com.INVALID>.

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 <kf...@mapr.com> 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 <vv...@gmail.com>
Sent: Tuesday, May 8, 2018 8:44:46 AM
To: user@drill.apache.org
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 <pe...@interswitchgroup.com>
пише:

> 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
>

Re: Apache Drill Automatically Converts Large Numbers to Exponents

Posted by Khurram Faraaz <kf...@mapr.com>.

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 <vv...@gmail.com>
Sent: Tuesday, May 8, 2018 8:44:46 AM
To: user@drill.apache.org
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 <pe...@interswitchgroup.com>
пише:

> 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
>

Re: Apache Drill Automatically Converts Large Numbers to Exponents

Posted by Vova Vysotskyi <vv...@gmail.com>.

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://drill.apache.org/docs/data-type-conversion/#other-data-type-conversions

Kind regards,
Volodymyr Vysotskyi


вт, 8 трав. 2018 о 18:36 Peter Edike <pe...@interswitchgroup.com>
пише:

> 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
>