You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "Billy(Yiming) Liu (JIRA)" <ji...@apache.org> on 2016/09/13 01:29:20 UTC

[jira] [Created] (KYLIN-2010) Date dictionary return wrong SQL result

Billy(Yiming) Liu created KYLIN-2010:
----------------------------------------

             Summary: 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: Billy(Yiming) Liu


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)