kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "skyyws"<>
Subject count if/case when SQL
Date Mon, 04 Dec 2017 07:21:18 GMT
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?


View raw message