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 >
