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 "Zhi Tang (Jira)" <ji...@apache.org> on 2023/05/25 07:15:00 UTC
[jira] [Commented] (IMPALA-12164) The query fails with " IllegalStateException: Illegal reference to non-materialized slot: tid=x sid=x"
[ https://issues.apache.org/jira/browse/IMPALA-12164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726070#comment-17726070 ]
Zhi Tang commented on IMPALA-12164:
-----------------------------------
The following query fails with IllegalStateException:
{code:java}
create table table_slot(f0 int, f1 int) stored as parquet;
set ANALYTIC_RANK_PUSHDOWN_THRESHOLD=0;
select f0, RANK() OVER(ORDER BY f0 DESC) AS rank_f0
from (SELECT f0
FROM table_slot
WHERE f1 = 0
and false) a order by f0;
ERROR: IllegalStateException: Illegal reference to non-materialized slot: tid=0 sid=1{code}
> The query fails with " IllegalStateException: Illegal reference to non-materialized slot: tid=x sid=x"
> ------------------------------------------------------------------------------------------------------
>
> Key: IMPALA-12164
> URL: https://issues.apache.org/jira/browse/IMPALA-12164
> Project: IMPALA
> Issue Type: Bug
> Affects Versions: Impala 4.1.2
> Reporter: Zhi Tang
> Assignee: Zhi Tang
> Priority: Major
> Attachments: image-2023-05-25-14-26-43-507.png
>
>
> The query failed in the compile execution plan phase. The stacktrace in logs:
> !image-2023-05-25-14-26-43-507.png|width=564,height=211!
--
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