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/21 00:54:20 UTC

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

     [ https://issues.apache.org/jira/browse/KYLIN-2010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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

    Assignee: liyang  (was: Billy(Yiming) Liu)

> 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: liyang
>
> 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)