[ https://issues.apache.org/jira/browse/HIVE-20310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vineet Garg updated HIVE-20310: ------------------------------- Description: *Reproducer* {code:sql} > 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); {code} was: *Reproducer* {code:sql} > create table tempty(i int); > create table t(c0 int); > explain select * from t where c0 > (select count(*) from tempty group by 1); {code} > Scalar subquery throws error when hive.optimize.remove.sq_count_check is on > --------------------------------------------------------------------------- > > Key: HIVE-20310 > URL: https://issues.apache.org/jira/browse/HIVE-20310 > Project: Hive > Issue Type: Bug > Components: Query Planning > Reporter: Vineet Garg > Assignee: Vineet Garg > Priority: Major > > *Reproducer* > {code:sql} > > 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); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)