kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean-Luc BELLIER (JIRA)" <>
Subject [jira] [Created] (KYLIN-3256) Filter of dates do not work
Date Fri, 16 Feb 2018 13:17:14 GMT
Jean-Luc BELLIER created KYLIN-3256:

             Summary: Filter of dates do not work
                 Key: KYLIN-3256
             Project: Kylin
          Issue Type: Bug
    Affects Versions: v2.2.0
            Reporter: Jean-Luc BELLIER



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'


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;


This message was sent by Atlassian JIRA

View raw message