Jestan,
It seems like a bug to me. What version of Phoenix are you using, and did
you create a ticket already?
On Tue, May 14, 2019 at 10:26 AM Jestan Nirojan
wrote:
> Hi,
>
> I am trying to use COALESCE function to handle default value in WHERE
> condition like below.
>
> select * from table1
Hi,
I am trying to use COALESCE function to handle default value in WHERE
condition like below.
select * from table1 where created_date >= coalesce(null, trunc(now(),
'day'));
But it throws NullPointerException
Caused by: java.lang.NullPointerException
at
Just took a look at the implementation, seems like Phoenix relies on the
first expression to not be an expression that is not just an explicit
"null" because it needs to evaluate for data type coercion. What's the use
case for specifying an explicit null?
On the other hand, the following should
Hi Jaanai,
Sorry I could not understand much from
https://issues.apache.org/jira/browse/PHOENIX-5268
Because of this recent change, there will not be a Phoenix release for
HBase 2.0.x in future Or there is an existing compatibility issue ?
What is the Phoenix version recommended for a new
Due to the incompatibility, you will need to wait for a new release in
the 5.x branch to get 5.x working with HBase 2.0.x.
Phoenix 5.0.0 is also only compatible with 2.0.0 (found this out a few
months ago) as PHOENIX-4826[1] adds support for HBase 2.0.1, but is
currently unreleased.
My
Hi, Jestan
Now Phoenix 5.0.0 is not compatible with HBase 2.0.5,
https://issues.apache.org/jira/browse/PHOENIX-5268
Jaanai Zhang
Best regards!
Jestan Nirojan 于2019年5月15日周三 上午5:04写道:
> Hi William,
>
> Thanks, It is working with
Hi William,
Thanks, It is working with coalesce(functionThatMightReturnNull(), now())
without an explicit null;
Phoenix Version is 5.0.0.0 which uses HBase 2.0.5
I have not opened any issue for this, I am not sure how it is suppose to
work.
I am developing a phoenix driver for metabase
Hello, I have HBase + PQS 4.14.1
If I'm trying to connect by think client - everything works, but if I'm
using thin client in PQS logs I can see continuous INFO messages
2019-05-14 13:53:58,701 INFO
org.apache.hadoop.hbase.client.RpcRetryingCaller: Call exception, tries=10,
retries=35,