[ https://issues.apache.org/jira/browse/KYLIN-2010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15527800#comment-15527800 ]
liyang commented on KYLIN-2010: ------------------------------- Actually, Jason & ZhiXiong has fixed the issue from GUI side. > Date dictionary return wrong SQL result > --------------------------------------- > > Key: KYLIN-2010 > URL: https://issues.apache.org/jira/browse/KYLIN-2010 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v1.5.3 > Reporter: Billy(Yiming) Liu > Assignee: Zhixiong Chen > Fix For: v1.5.4.1 > > > One dimension calls DAY_ID, varchar type, data likes "20160401". The cube is > built successfully with "Date" dictionary for the DAY_ID column. But query > 'select count(*), DAY_ID from table group by DAY_ID', the result DAY_ID > column is '1459468800000', not '20160401'. If build with "Dict" dictionary, > the result will be '20160401'. -- This message was sent by Atlassian JIRA (v6.3.4#6332)