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