[IMPALA-12097] AnalysisException for a COUNT(*) query on Iceberg table

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.3.0
• Component/s: Frontend
• Epic Color: ghx-label-12
• Assignee: Li Penglin
• Reporter: Aman Sinha
• Created: 25/Apr/23 07:04
• Updated: 21/May/23 16:03
• Resolved: 21/May/23 16:03

Description

Repro below:

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

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.

Issue Links

• is caused by: IMPALA-11802 Optimize count(*) queries for Iceberg V2 tables