Return-Path: <issues-return-31878-archive-asf-public=cust-asf.ponee.io@drill.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id 65414200B2B
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Tue, 14 Jun 2016 00:18:05 +0200 (CEST)
Received: by cust-asf.ponee.io (Postfix)
	id 63D13160A5E; Mon, 13 Jun 2016 22:18:05 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id B3727160A3C
	for <archive-asf-public@cust-asf.ponee.io>; Tue, 14 Jun 2016 00:18:04 +0200 (CEST)
Received: (qmail 77104 invoked by uid 500); 13 Jun 2016 22:18:03 -0000
Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@drill.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@drill.apache.org>
List-Post: <mailto:issues@drill.apache.org>
List-Id: <issues.drill.apache.org>
Reply-To: dev@drill.apache.org
Delivered-To: mailing list issues@drill.apache.org
Received: (qmail 77083 invoked by uid 99); 13 Jun 2016 22:18:03 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Jun 2016 22:18:03 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id C39B12C14F9
	for <issues@drill.apache.org>; Mon, 13 Jun 2016 22:18:03 +0000 (UTC)
Date: Mon, 13 Jun 2016 22:18:03 +0000 (UTC)
From: "Rahul Challapalli (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12952230.1458600007000.1670.1465856283798@Atlassian.JIRA>
In-Reply-To: <JIRA.12952230.1458600007000@Atlassian.JIRA>
References: <JIRA.12952230.1458600007000@Atlassian.JIRA> <JIRA.12952230.1458600007103@arcas>
Subject: [jira] [Commented] (DRILL-4525) Query with BETWEEN clause on Date
 and Timestamp values fails with Validation Error
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
archived-at: Mon, 13 Jun 2016 22:18:05 -0000


    [ https://issues.apache.org/jira/browse/DRILL-4525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15328419#comment-15328419 ] 

Rahul Challapalli commented on DRILL-4525:
------------------------------------------

Any idea when I can expect this to be resolved?

> 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
>
> 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)