cloud-fan commented on a change in pull request #26736: [SPARK-30098][SQL] Use default datasource as provider for CREATE TABLE syntax URL: https://github.com/apache/spark/pull/26736#discussion_r353179186
########## File path: sql/hive/src/test/scala/org/apache/spark/sql/hive/HiveShowCreateTableSuite.scala ########## @@ -177,17 +178,24 @@ class HiveShowCreateTableSuite extends ShowCreateTableSuite with TestHiveSinglet } test("SPARK-24911: keep quotes for nested fields in hive") { - withTable("t1") { - val createTable = "CREATE TABLE `t1`(`a` STRUCT<`b`: STRING>)" - sql(createTable) - val shownDDL = sql(s"SHOW CREATE TABLE t1") - .head() - .getString(0) - .split("\n") - .head - assert(shownDDL == createTable) + val originalCreateHiveTable = TestHive.conf.createHiveTableByDefaultEnabled + try { + TestHive.conf.setConf(SQLConf.LEGACY_CREATE_HIVE_TABLE_BY_DEFAULT_ENABLED, true) + withTable("t1") { + val createTable = "CREATE TABLE `t1`(`a` STRUCT<`b`: STRING>)" + sql(createTable) + val shownDDL = sql(s"SHOW CREATE TABLE t1") + .head() + .getString(0) + .split("\n") + .head + assert(shownDDL == createTable) Review comment: This doesn't matter. SHOW CREATE TABLE needs to return a SQL that can run. It's OK to have some extra spaces in the SQL. ---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org