Hi, nokkon
What’s your Kylin version? Can you provide the log of the query and the definition of Cube/Model? 发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用 ________________________________ 发件人: nokkon1314@ <gmail.com nokkon1...@gmail.com> 发送时间: Monday, March 4, 2019 11:28:25 AM 收件人: dev@kylin.apache.org 主题: Why GROUP BY can't get the right result in the following situation? Expression: select YEAR(ORDERDATE) AS "calc(1692598041)(0)" from orders2 Results: calc(1692598041)(0) 2013 2013 2014 2015 2015 But ,when I add the GROUP BY clause: select YEAR(ORDERDATE) AS "calc(1692598041)(0)" from orders2 GROUP BY (YEAR(ORDERDATE)) Results: calc(1692598041)(0) 2013 I don’t know why there just return one record. Do you have any suggestions?
