HyukjinKwon commented on a change in pull request #25124:
[SPARK-28282][SQL][PYTHON][TESTS] Convert and port 'inline-table.sql' into UDF
test base
URL: https://github.com/apache/spark/pull/25124#discussion_r305188201
##########
File path:
sql/core/src/test/resources/sql-tests/results/udf/udf-inline-table.sql.out
##########
@@ -0,0 +1,153 @@
+-- Automatically generated by SQLQueryTestSuite
+-- Number of queries: 17
+
+
+-- !query 0
+select udf(col1), udf(col2) from values ("one", 1)
+-- !query 0 schema
+struct<CAST(udf(cast(col1 as string)) AS STRING):string,CAST(udf(cast(col2 as
string)) AS INT):int>
+-- !query 0 output
+one 1
+
+
+-- !query 1
+select udf(col1), udf(udf(col2)) from values ("one", 1) as data
+-- !query 1 schema
+struct<CAST(udf(cast(col1 as string)) AS
STRING):string,CAST(udf(cast(cast(udf(cast(col2 as string)) as int) as string))
AS INT):int>
+-- !query 1 output
+one 1
+
+
+-- !query 2
+select udf(a), b from values ("one", 1) as data(a, b)
+-- !query 2 schema
+struct<CAST(udf(cast(a as string)) AS STRING):string,b:int>
+-- !query 2 output
+one 1
+
+
+-- !query 3
+select udf(a) from values 1, 2, 3 as data(a)
+-- !query 3 schema
+struct<CAST(udf(cast(a as string)) AS INT):int>
+-- !query 3 output
+1
+2
+3
+
+
+-- !query 4
+select udf(a), b from values ("one", 1), ("two", 2), ("three", null) as
data(a, b)
+-- !query 4 schema
+struct<CAST(udf(cast(a as string)) AS STRING):string,b:int>
+-- !query 4 output
+one 1
+three NULL
+two 2
+
+
+-- !query 5
+select a, udf(b) from values ("one", null), ("two", null) as data(a, b)
+-- !query 5 schema
+struct<>
+-- !query 5 output
+org.apache.spark.sql.AnalysisException
+cannot resolve 'CAST(udf(cast(b as string)) AS NULL)' due to data type
mismatch: cannot cast string to null; line 1 pos 10
Review comment:
Hm, yea let's do that.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
