Hi Silas, Thanks for your advice. However, This SQL execute failed on kylin. The error tips are "Can't find any realization. Please confirm with providers.", but other normal SQL can get correct result. Do I need to define sum measure for dimension A? I use kylin 2.0.0-hbase 0.98.8 version.
2017-12-05 skyyws 发件人：Ge Silas <[email protected]> 发送时间：2017-12-04 21:11 主题：Re: count if/case when SQL 收件人："[email protected]"<[email protected]> 抄送： Hi, This could be an issue… Does below serve what you want? select sum(case when A=‘a1’ then 1 else 0 end) Thanks, Silas On 4 Dec 2017, at 3:21 PM, skyyws <[email protected]> wrote: Hello all, I found that kylin not support count if/cast when sql which mysql supported, like this: select count(if(A='a1',true,null)) as a1, count(if(A='a2',true,null)) as a2 from table select count(case when A='a1' then true else null end) a1, count(case when A='a2' then true else null end) a2 from table Some of our users use "union" replace this function which lead to a very long sql. So I want to ask, if kylin will support this sql in the near future? 2017-12-04 skyyws
