kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ge Silas <>
Subject Re: count if/case when SQL
Date Mon, 04 Dec 2017 13:11:21 GMT

This could be an issue… Does below serve what you want?

select sum(case when A=‘a1’ then 1 else 0 end)


On 4 Dec 2017, at 3:21 PM, skyyws <<>> 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?


View raw message