phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Singhal <ankitsingha...@gmail.com>
Subject Re: can I prevent rounding of a/b when a and b are integers
Date Wed, 21 Sep 2016 17:12:45 GMT
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 <jamestaylor@apache.org>
wrote:

> 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 <Noam.Bulvik@teoco.com>
> wrote:
>
>> Hi,
>>
>>
>>
>> When I do something like select 1/3 from <my table>  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
>>
>>
>>
>> *Noam Bulvik*
>>
>>
>>
>> ------------------------------
>>
>> PRIVILEGED AND CONFIDENTIAL
>> PLEASE NOTE: The information contained in this message is privileged and
>> confidential, and is intended only for the use of the individual to whom it
>> is addressed and others who have been specifically authorized to receive
>> it. If you are not the intended recipient, you are hereby notified that any
>> dissemination, distribution or copying of this communication is strictly
>> prohibited. If you have received this communication in error, or if any
>> problems occur with transmission, please contact sender. Thank you.
>>
>
>

Mime
View raw message