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.
create table test(id int);
insert into table test values(1);
select id from test except select id from test;