COALESCE Function Not Working With NULL Values

2019-05-14 Thread Jestan Nirojan
ing something wrong here or is coalesce suppose to return a non null value ? thanks and regards, -Jestan Nirojan

Re: COALESCE Function Not Working With NULL Values

2019-05-14 Thread Jestan Nirojan
deployment ? :) , thanks and regards, -Jestan Nirojan On Wed, May 15, 2019 at 7:04 AM Jaanai Zhang wrote: > Hi, Jestan > > Now Phoenix 5.0.0 is not compatible with HBase 2.0.5, > https://issues.apache.org/jira/browse/PHOENIX-5268 > > >J

Re: COALESCE Function Not Working With NULL Values

2019-05-15 Thread Jestan Nirojan
oy something right now, I'd suggest using the > latest version of the 4.x.x branch (4.14.1) and HBase 1.4.x. > > Francis > > [1] https://issues.apache.org/jira/browse/PHOENIX-4826 > > On 15/05/2019 2:50 pm, Jestan Nirojan wrote: > > Hi Jaanai, > > > > Sorry I

Re: COALESCE Function Not Working With NULL Values

2019-05-14 Thread Jestan Nirojan
id >> 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. >>