[SPARK-26307] Fix CTAS when INSERT a partitioned table using Hive serde

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3.2, 2.4.0
• Fix Version/s: 2.3.3, 2.4.1, 3.0.0
• Component/s: SQL
• Assignee: Xiao Li
• Reporter: Xiao Li
• Created: 07/Dec/18 17:38
• Updated: 10/Dec/18 07:01
• Resolved: 10/Dec/18 07:01

Description

    withTable("hive_test") {
      withSQLConf(
          "hive.exec.dynamic.partition.mode" -> "nonstrict") {
        val df = Seq(("a", 100)).toDF("part", "id")
        df.write.format("hive").partitionBy("part")
          .mode("overwrite").saveAsTable("hive_test")
        df.write.format("hive").partitionBy("part")
          .mode("append").saveAsTable("hive_test")
      }
    }

Issue Links

• links to: [Github] Pull Request #23255 (gatorsmile)