[HIVE-21540] Query with join condition having date literal throws SemanticException.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0, 3.1.1
• Fix Version/s: 3.1.2, 3.2.0, 4.0.0-alpha-1
• Component/s: Query Planning
• Labels: Analyzer DateField pull-request-available
• Target Version/s: 3.1.0, 3.1.1, 4.0.0
• Assignee: Sankar Hariappan
• Reporter: Sankar Hariappan
• Created: 29/Mar/19 08:29
• Updated: 21/Oct/22 06:57
• Resolved: 01/Apr/19 10:30

Description

This semantic exception is thrown for the following query.
SemanticException '2019-03-20' encountered with 0 children

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;

When the WHERE condition below is commented out, the query completes successfully.
where d2.dd between start_dd and end_dd
------------------------------------------------

Issue Links

• links to: GitHub Pull Request #584