according to this JIRA, sum(case when ) is currently not supported by kylin
https://issues.apache.org/jira/browse/KYLIN-2341 On Tue, Dec 5, 2017 at 10:11 AM, skyyws <[email protected]> wrote: > 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 > > > -- Jingke He [email protected] 410-336-2228
