Jean-Luc BELLIER created KYLIN-3256:
---------------------------------------
Summary: Filter of dates do not work
Key: KYLIN-3256
URL: https://issues.apache.org/jira/browse/KYLIN-3256
Project: Kylin
Issue Type: Bug
Affects Versions: v2.2.0
Reporter: Jean-Luc BELLIER
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)
