kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shaofeng SHI (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (KYLIN-3256) Filter of dates do not work
Date Fri, 14 Sep 2018 03:53:00 GMT

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

Shaofeng SHI updated KYLIN-3256:
--------------------------------
    Fix Version/s: v2.6.0
      Component/s: Query Engine

Will investigate this. Sometimes this is related with the incorrect data type.

> Filter of dates do not work
> ---------------------------
>
>                 Key: KYLIN-3256
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3256
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: v2.2.0
>            Reporter: Jean-Luc BELLIER
>            Priority: Major
>             Fix For: v2.6.0
>
>
> Hello,
>  
> I am wondering how to filter date columns with Kylin.
> I am working with the sample cube of the learn_kylin project. I have slightly modified
the cube to add a few more columns, but that is all.
> In the advanced section, I put KYLIN_SALES.PART_DT in the 'Rowkeys' section, defined
as 'date' type.
>  
> I would like to add a filter like 'WHERE KYLIN_SALES.DT_PART = '2012-06-24'
> but the Kylin interface gives me a mistake : 'error while compiling generated Java code'
> This works fine with hive console.
> I also tried with TO_DATE('2012-06-24').
> Using "WHERE KYLIN_SALES.DT_PART BETWEEN '2012-06-24'  AND '2012-06-25'", it works
fine.
>  
> Are  there limitations or internal transformations on the 'date' type in Kylin ?
>  
> Thank you for your help. Have a good day.
>  
> Best regards;
> Jean-Luc.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message