[ https://issues.apache.org/jira/browse/IMPALA-12097?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17718353#comment-17718353 ]
ASF subversion and git services commented on IMPALA-12097: ---------------------------------------------------------- Commit 8b6f9273ce012877747c8e06aada289686be5de4 in impala's branch refs/heads/master from LPL [ https://gitbox.apache.org/repos/asf?p=impala.git;h=8b6f9273c ] IMPALA-12097: WITH CLAUSE should be skipped when optimizing COUNT(*) query on Iceberg table When optimizing the simple count star query for the Iceberg table, the WITH CLAUSE should be skipped, but that doesn't mean the SQL can't be optimized, because when the WITH CLAUSE is inlined, the final statement is optimized by the CountStarToConstRule. Testing: * Add e2e tests Change-Id: I7b21cbea79be77f2ea8490bd7f7b2f62063eb0e4 Reviewed-on: http://gerrit.cloudera.org:8080/19811 Reviewed-by: Impala Public Jenkins <impala-public-jenk...@cloudera.com> Tested-by: Impala Public Jenkins <impala-public-jenk...@cloudera.com> > 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 > > 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