You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Uroš Bojanić (Jira)" <ji...@apache.org> on 2026/09/29 19:04:00 UTC
[jira] [Resolved] (SPARK-59323) Referencing a temporary view whose IDENTIFIER clause reads a session variable fails with NOT_A_CONSTANT_STRING
[ https://issues.apache.org/jira/browse/SPARK-59323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Uroš Bojanić resolved SPARK-59323.
----------------------------------
Fix Version/s: 4.4.0
Resolution: Fixed
Issue resolved by pull request 58606
[https://github.com/apache/spark/pull/58606]
> Referencing a temporary view whose IDENTIFIER clause reads a session variable fails with NOT_A_CONSTANT_STRING
> --------------------------------------------------------------------------------------------------------------
>
> Key: SPARK-59323
> URL: https://issues.apache.org/jira/browse/SPARK-59323
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 4.3.0
> Reporter: Stevo Mitric
> Assignee: Stevo Mitric
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.4.0
>
>
> DECLARE OR REPLACE VARIABLE relation_name STRING DEFAULT 'src';
> CREATE OR REPLACE TEMPORARY VIEW src AS SELECT 1 AS c1;
> CREATE OR REPLACE TEMPORARY VIEW v AS SELECT * FROM IDENTIFIER(relation_name);
> SELECT * FROM v;
> CREATE VIEW succeeds; the SELECT fails:
> [NOT_A_CONSTANT_STRING.NOT_CONSTANT] The expression relation_name used for the routine or clause IDENTIFIER must be a constant STRING which is NOT NULL.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org