[
https://issues.apache.org/jira/browse/IMPALA-12097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aman Sinha resolved IMPALA-12097.
---------------------------------
Fix Version/s: Impala 4.3.0
Resolution: Fixed
> 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
> Assignee: Li Penglin
> Priority: Major
> Fix For: Impala 4.3.0
>
>
> 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)
