[ https://issues.apache.org/jira/browse/HIVE-21540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sankar Hariappan updated HIVE-21540: ------------------------------------ Target Version/s: 3.1.1, 3.1.0, 4.0.0 (was: 3.1.0, 4.0.0, 3.1.1) Status: Open (was: Patch Available) > 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.1, 3.1.0, 4.0.0 > Reporter: Sankar Hariappan > Assignee: Sankar Hariappan > Priority: Major > Labels: Analyzer, DateField, pull-request-available > Attachments: HIVE-21540.01.patch > > 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)