Max Gekk created SPARK-51289:
--------------------------------

             Summary: Internal error on RETURNS TABLE
                 Key: SPARK-51289
                 URL: https://issues.apache.org/jira/browse/SPARK-51289
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 4.0.0
            Reporter: Max Gekk


While testing the 4.0.0-rc1, I have found the internal error on the new feature:

{code:sql}
spark-sql (default)> CREATE TEMPORARY FUNCTION fa(x INT) RETURNS TABLE (a INT) 
RETURN SELECT x;
Time taken: 0.325 seconds
spark-sql (default)> select * from fa(1);
{code}

{code:java}
[INTERNAL_ERROR] SQL table function plan should be rewritten during analysis: 
SQLTableFunction fa, 
SQLFunction(fa,Some(StructType(StructField(x,IntegerType,true))),Right(StructType(StructField(a,IntegerType,true))),None,Some(SELECT
 x),None,Some(true),None,true,HashMap(referredTempFunctionsNames -> [], 
catalogAndNamespace.part.0 -> spark_catalog, referredTempViewNames -> [], 
catalogAndNamespace.part.1 -> default, 
sqlConfig.spark.sql.artifact.isolation.enabled -> false, 
catalogAndNamespace.numParts -> 2, 
sqlConfig.spark.sql.datetime.java8API.enabled -> true, 
referredTempVariableNames -> []),None,1740153099265), [1], [a#3]
 SQLSTATE: XX000
{code}





--
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