I think this is a problem with the WHERE clause. NULL values are neither equal nor not-equal to any other values. You might need to add "OR API_KEY IS NULL" to the WHERE clause.
Lukas On Fri, Aug 12, 2016 at 9:51 AM, ankit beohar <ankitbeoha...@gmail.com> wrote: > Hi Lukáš/James, > > I have one table in which only one rowkey is available and for my null > check case I am firing below queries and in that null check is not working:- > > [image: Inline image 1] > > Please see and let me know if I am doing right thing or missed something. > > Best Regards, > ANKIT BEOHAR > > > On Thu, Aug 11, 2016 at 9:18 PM, James Taylor <jamestay...@apache.org> > wrote: > >> Lukáš is correct, but if the CASE WHEN variant of the same didn't work, >> please file a JIRA (ideally with a unit test that repros the problem). >> >> Thanks, >> James >> >> On Thu, Aug 11, 2016 at 12:20 AM, Lukáš Lalinský <lalin...@gmail.com> >> wrote: >> >>> On Thu, Aug 11, 2016 at 9:00 AM, ankit beohar <ankitbeoha...@gmail.com> >>> wrote: >>> >>>> I want to implement If null in apache phoenix like mysql. >>>> >>>> select ifnull(rowkey,myvalue),ifnull(col1,mycolvalue) from table where >>>> rowkey='abc'; >>>> >>>> I tried below query but did not work:- >>>> >>>> select case when APP_KEY is null then 'nullvalue' else APP_KEY end from >>>> "CheckDump"; >>>> >>> >>> The standard SQL function for this is coalesce(col, 'nullvalue'). >>> >>> https://phoenix.apache.org/language/functions.html#coalesce >>> >>> Lukas >>> >> >> >
