day is the reserve keyword in kylin, try this: select “DAY",sum(sendmsgs) from sendlog_daily group by “DAY"
> 在 2016年5月23日，17:41，zhangrongkun <[email protected]> 写道： > > At query time,my sql is:select day ,sum(sendmsgs) from sendlog_daily group by > day; but result exception : > > <http://apache-kylin.74782.x6.nabble.com/file/n4674/QQ%E6%88%AA%E5%9B%BE20160523175516.png> > > > > ,But my sql is :select sex ,sum(sendmsgs) from sendlog_daily group by sex; > It return right > > -- > View this message in context: > http://apache-kylin.74782.x6.nabble.com/Is-day-type-a-special-date-type-tp4674.html > Sent from the Apache Kylin mailing list archive at Nabble.com.
