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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: Peter Varga
• Reporter: Peter Varga
• Created: 06/Oct/20 06:36
• Updated: 17/Nov/22 08:47
• 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 Compilation fails due to equivalence mapping violation when CTE materialization is enabled
• links to: GitHub Pull Request #1555