You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Aman Sinha (Jira)" <ji...@apache.org> on 2023/04/25 07:05:00 UTC
[jira] [Created] (IMPALA-12097) AnalysisException for a COUNT(*) query on Iceberg table
Aman Sinha created IMPALA-12097:
-----------------------------------
Summary: 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
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