[
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: [email protected]
For additional commands, e-mail: [email protected]
