Sankar Hariappan created HIVE-21540: ---------------------------------------
Summary: 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 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)