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

["Aman Sinha (Jira)" <ji...@apache.org>]

    [ 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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org