Aman Sinha created IMPALA-12097: ----------------------------------- Summary: AnalysisException for a COUNT(*) query on Iceberg table Key: IMPALA-12097 URL: https://issues.apache.org/jira/browse/IMPALA-12097 Project: IMPALA Issue Type: Bug Components: Frontend Reporter: Aman Sinha
Repro below: {noformat} create table t1_ice (a1 int) stored by iceberg; create table t2_ice (a2 int) stored by iceberg; insert into t1_ice values (10); insert into t2_ice values (10); with a as (select count(*) from t1_ice), b as (select count(*) from t2_ice) select * from a, b; ERROR: AnalysisException: aggregation without a FROM clause is not allowed {noformat} This appears to be caused by IMPALA-11802. If I comment out the invocations of the new optimizePlainCountStarQueryV1() and V2() in SelectStmt.java, the query works fine. -- This message was sent by Atlassian Jira (v8.20.10#820010)