[ https://issues.apache.org/jira/browse/IMPALA-12097?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17716126#comment-17716126 ]
Aman Sinha commented on IMPALA-12097: ------------------------------------- [~lipenglin] would you be interested in taking a look ? (since you had worked on IMPALA-11802). cc [~boroknagyz] > 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 > Priority: Major > > 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) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org