Stevo Mitric created SPARK-59323:
------------------------------------

             Summary: 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: Spark Core
    Affects Versions: 4.3.0
            Reporter: Stevo Mitric


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]

Reply via email to