Hi,
When I do something like select 1/3 from the result will be integer
value (0) and not double or alike(0.33). Is there some configuration that
can force the result to be double
BTW - when executing the same query in oracle (select 1/3 from dual ) I get
correct result same in impala
N
Hi Noam,
Please file a JIRA. As a workaround, you can do SELECT 1.0/3.
Thanks,
James
On Wed, Sep 21, 2016 at 12:48 AM, Bulvik, Noam
wrote:
> Hi,
>
>
>
> When I do something like select 1/3 from the result will be
> integer value (0) and not double or alike(0.33….). Is there some
> configuratio
Adding some more workaround , if you are working on column:-
select cast(col_int1 as decimal)/col_int2;
select col_int1*1.0/3;
On Wed, Sep 21, 2016 at 8:33 PM, James Taylor
wrote:
> Hi Noam,
> Please file a JIRA. As a workaround, you can do SELECT 1.0/3.
> Thanks,
> James
>
> On Wed, Sep 21, 2
...@apache.org]
Sent: Wednesday, September 21, 2016 6:03 PM
To: user
Subject: Re: can I prevent rounding of a/b when a and b are integers
Hi Noam,
Please file a JIRA. As a workaround, you can do SELECT 1.0/3.
Thanks,
James
On Wed, Sep 21, 2016 at 12:48 AM, Bulvik, Noam
mailto:noam.bul...@teoco.com
On Thu, 2016-09-22 at 05:39 +, Bulvik, Noam wrote:
We have an app that let user write their own SQL
Um, do they write DROP TABLE statements in there?
Elsevier Limited. Registered Office: The Boulevard, Langford Lane, Kidlington,
Oxford, OX5 1GB, United Ki
I think it is fairly standard in programming languages for / to mean
integer division when the operands used are integers. Therefore 1/3=0 is
not a surprising result to me; other programming languages I have worked in
give 1/3=0. However if one of the operands to / is a decimal, the result
is als
get wrong results unless you will start implementing workarounds
From: John Hancock [mailto:jhancock1...@gmail.com]
Sent: Thursday, September 22, 2016 12:56 PM
To: user@phoenix.apache.org
Subject: Re: can I prevent rounding of a/b when a and b are integers
I think it is fairly standard in
AM
To: user@phoenix.apache.org
Subject: RE: can I prevent rounding of a/b when a and b are integers
I checked both oracle and impala and in both 1/3 is 0.333 and not 0.
I think that SQL writer is not a programmer and he does not care about data
type. He just want to get the correct results. BTW – it