subject:"UNION ALL is not working with count\(\)"

Re: UNION ALL is not working with count()

2018-10-18 Thread ShaoFeng Shi

JIRA created for it: https://issues.apache.org/jira/browse/KYLIN-3637 ShaoFeng Shi 于2018年10月17日周三下午11:04写道： > Hi Yi, > > This is a bug. Could you please report a JIRA to Kylin? Thank you! > > yiwang <756470...@qq.com> 于2018年10月15日周一下午2:28写道： > >> Hi Kylin Team, >> >> When I ran sql "SELECT

Re: UNION ALL is not working with count()

2018-10-17 Thread ShaoFeng Shi

Hi Yi, This is a bug. Could you please report a JIRA to Kylin? Thank you! yiwang <756470...@qq.com> 于2018年10月15日周一下午2:28写道： > Hi Kylin Team, > > When I ran sql "SELECT count(TRANS_ID) as TRANS_ID FROM KYLIN_SALES where > TRANS_ID <> 1 union all select count(TRANS_ID) as TRANS_ID FROM >

UNION ALL is not working with count()

2018-10-15 Thread yiwang

Hi Kylin Team, When I ran sql "SELECT count(TRANS_ID) as TRANS_ID FROM KYLIN_SALES where TRANS_ID <> 1 union all select count(TRANS_ID) as TRANS_ID FROM KYLIN_SALES" on sample cube. Got Error: Error while compiling generated Java code: public static class Record2_1 implements