[HIVE-20310] Scalar subquery throws error when hive.optimize.remove.sq_count_check is on

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Component/s: Query Planning
• Target Version/s: 4.0.0
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 03/Aug/18 22:10
• Updated: 06/Aug/18 22:39
• Resolved: 06/Aug/18 22:39

Description

Reproducer

> set hive.optimize.remove.sq_count_check=true;
> create table tempty(i int);
> create table t(c0 int);
> explain select * from t where c0 > (select count(*) from tempty group by 1);