[jira] [Work logged] (HIVE-21540) Query with join condition having date literal throws SemanticException.

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-21540?focusedWorklogId=220953&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-220953 ]

ASF GitHub Bot logged work on HIVE-21540:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 31/Mar/19 07:46
            Start Date: 31/Mar/19 07:46
    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:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 220953)
            Time Spent: 10m
    Remaining Estimate: 0h

> 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, 4.0.0
>            Reporter: Sankar Hariappan
>            Assignee: Sankar Hariappan
>            Priority: Major
>              Labels: Analyzer, DateField, pull-request-available
>          Time Spent: 10m
>  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)