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 <jamestay...@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.bul...@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. >> > >
