[
https://issues.apache.org/jira/browse/HIVE-21540?focusedWorklogId=225761&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-225761
]
ASF GitHub Bot logged work on HIVE-21540:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 10/Apr/19 18:21
Start Date: 10/Apr/19 18:21
Worklog Time Spent: 10m
Work Description: sankarh commented on pull request #584: HIVE-21540:
Query with join condition having date literal throws SemanticException.
URL: https://github.com/apache/hive/pull/584
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 225761)
Time Spent: 20m (was: 10m)
> Query with join condition having date literal throws SemanticException.
> -----------------------------------------------------------------------
>
> Key: HIVE-21540
> URL: https://issues.apache.org/jira/browse/HIVE-21540
> Project: Hive
> Issue Type: Bug
> Components: Query Planning
> Affects Versions: 3.1.0, 3.1.1
> Reporter: Sankar Hariappan
> Assignee: Sankar Hariappan
> Priority: Major
> Labels: Analyzer, DateField, pull-request-available
> Fix For: 3.1.0, 4.0.0, 3.1.1
>
> Attachments: HIVE-21540.01.patch
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> This semantic exception is thrown for the following query.
> *SemanticException '2019-03-20' encountered with 0 children*
> {code}
> create table date_1 (key int, dd date);
> create table date_2 (key int, dd date);
> select d1.key, d2.dd from(
> select key, dd as start_dd, current_date as end_dd from date_1) d1
> join date_2 as d2 on d1.key = d2.key where d2.dd between start_dd and
> end_dd;
> {code}
> When the WHERE condition below is commented out, the query completes
> successfully.
> where d2.dd between start_dd and end_dd
> ------------------------------------------------
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
