[HIVE-24233] except subquery throws nullpointer with cbo disabled

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0
• Labels: pull-request-available
• Assignee: Peter Varga
• Reporter: Peter Varga
• Created: 06/Oct/20 06:36
• Updated: 18/Nov/20 14:11
• Resolved: 09/Nov/20 12:50

Description

Except and intersect was only implemented with Calcite in HIVE-12764. If cbo is disabled it would just throw a nullpointer exception. We should at least throw a SemanticException stating this is not supported.

Repro:
set hive.cbo.enable=false;
create table test(id int);
insert into table test values(1);
select id from test except select id from test;

Issue Links

• is related to: HIVE-24167 TPC-DS query 14 fails while generating plan for the filter
• links to: GitHub Pull Request #1555