[ https://issues.apache.org/jira/browse/KYLIN-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367947#comment-16367947 ]
Vsevolod Ostapenko commented on KYLIN-3256: ------------------------------------------- There is already an open bug for error in generated code, see KYLIN-3126 > 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 > Priority: Major > > 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)