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

Re: can I prevent rounding of a/b when a and b are integers

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

Phoenix ResultSet.next() takes a long time for first row

Hi, I'm using Apache Phoenix core 4.4.0-HBase-1.1 library to query the data available on Phoenix server. preparedStatement.executeQuery() seems to be taking less time. But to enter into *while (rs.next()) {} *takes a long time. I would like to know what is causing the delay to make the

Re: property object is being modified

Sounds like the thin driver should be making a copy of the properties if its going to be modifying it. Want to open a JIRA issue? Prabhjyot Singh wrote: Hi, I'm using DriverManager.getConnection(url, properties) using following properties url ->

can I prevent rounding of a/b when a and b are integers

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

RE: can I prevent rounding of a/b when a and b are integers

Thanks for the workaround , but it is not a solution for our case. We have an app that let user write their own SQL and we can’t tell them to always write int numbers as xxx.0 I created https://issues.apache.org/jira/browse/PHOENIX-3312 Regards, Noam From: James Taylor