[ https://issues.apache.org/jira/browse/DRILL-4525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15335128#comment-15335128 ]
Jinfeng Ni commented on DRILL-4525: ----------------------------------- I agreed with what [~julianhyde] suggested. The change should be in Calcite. Opened a Calcite JIRA: https://issues.apache.org/jira/browse/CALCITE-1296 If we adopt the proposal in this PR, Drill has to add a new wrapper and maintain this code in the future. Fixing in Calcite seems to be a better approach. Given this, we may not be able to fix this issue in 1.7.0. However, there would be a work-around for this issue : add explicit cast to make the query pass the check enforced by Calcite. > Query with BETWEEN clause on Date and Timestamp values fails with Validation > Error > ---------------------------------------------------------------------------------- > > Key: DRILL-4525 > URL: https://issues.apache.org/jira/browse/DRILL-4525 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Reporter: Abhishek Girish > Assignee: Sean Hsuan-Yi Chu > Priority: Critical > Fix For: 1.7.0 > > > Query: (simplified variant of TPC-DS Query37) > {code} > SELECT > * > FROM > date_dim > WHERE > d_date BETWEEN Cast('1999-03-06' AS DATE) AND ( > Cast('1999-03-06' AS DATE) + INTERVAL '60' day) > LIMIT 10; > {code} > Error: > {code} > Error: VALIDATION ERROR: From line 6, column 8 to line 7, column 64: Cannot > apply 'BETWEEN ASYMMETRIC' to arguments of type '<ANY> BETWEEN ASYMMETRIC > <DATE> AND <TIMESTAMP(0)>'. Supported form(s): '<COMPARABLE_TYPE> BETWEEN > <COMPARABLE_TYPE> AND <COMPARABLE_TYPE>' > SQL Query null > [Error Id: 223fb37c-f561-4a37-9283-871dc6f4d6d0 on abhi2:31010] > (state=,code=0) > {code} > This is a regression from 1.6.0. -- This message was sent by Atlassian JIRA (v6.3.4#6332)