答复: Why GROUP BY can't get the right result in the following situation?

[Na Zhai <na...@kyligence.io>]

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 nokkon1314@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?