phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ankit beohar <ankitbeoha...@gmail.com>
Subject Phoenix Ifnull
Date Thu, 11 Aug 2016 07:00:47 GMT
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

Mime
View raw message