[KYLIN-3256] Filter of dates do not work

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: v2.2.0
• Component/s: Query Engine
• Assignee: Unassigned
• Reporter: Jean-Luc BELLIER
• Created: 16/Feb/18 13:16
• Updated: 20/Sep/18 01:45
• Resolved: 20/Sep/18 01:45

Description

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.

Issue Links

• duplicates: KYLIN-3126 Query fails with "Error while compiling generated Java code" when equality condition is used, and works when equivalent IN clause is specified