Phoenix Ifnull

[ankit beohar]

Hi All,

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";


Best Regards,
ANKIT BEOHAR