LantaoJin commented on a change in pull request #28833:
URL: https://github.com/apache/spark/pull/28833#discussion_r448143565
##########
File path:
sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/HiveDDLSuite.scala
##########
@@ -2309,6 +2309,108 @@ class HiveDDLSuite
}
}
+ test("SPARK-20680: Spark-sql do not support for void column datatype") {
+ withTable("t") {
+ withView("tabVoidType") {
+ val client =
+
spark.sharedState.externalCatalog.unwrapped.asInstanceOf[HiveExternalCatalog].client
+ client.runSqlHive("CREATE TABLE t (t1 int)")
+ client.runSqlHive("INSERT INTO t VALUES (3)")
+ client.runSqlHive("CREATE VIEW tabVoidType AS SELECT NULL AS col FROM
t")
Review comment:
`client.runSqlHive("CREATE TABLE tabVoidType AS SELECT NULL AS col FROM
t")` will throw
FAILED: SemanticException [Error 10305]: CREATE-TABLE-AS-SELECT creates a
VOID type, please use CAST to specify the type, near field: col
----------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]