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
