[jira] [Created] (SPARK-28050) DataFrameWriter support insertInto a specific table partition

["Leanken.Lin (JIRA)" <ji...@apache.org>]

Leanken.Lin created SPARK-28050:
-----------------------------------

             Summary: DataFrameWriter support insertInto a specific table partition
                 Key: SPARK-28050
                 URL: https://issues.apache.org/jira/browse/SPARK-28050
             Project: Spark
          Issue Type: New Feature
          Components: SQL
    Affects Versions: 2.4.3, 2.3.3
            Reporter: Leanken.Lin
             Fix For: 2.4.3, 2.3.3


val ptTableName = "mc_test_pt_table"
sql(s"CREATE TABLE ${ptTableName} (name STRING, num BIGINT) PARTITIONED BY (pt1 STRING, pt2 STRING)")

val df = spark.sparkContext.parallelize(0 to 99, 2)
  .map(f =>
    {
      (s"name-$f", f)
    })
  .toDF("name", "num")

// if i want to insert df into a specific partition
// say pt1='2018',pt2='0601' current api does not supported
// only with following work around
df.createOrReplaceTempView(s"${ptTableName}_tmp_view")
sql(s"insert into table ${ptTableName} partition (pt1='2018', pt2='0601') select * from ${ptTableName}_tmp_view")

Propose to have another API in DataframeWriter that can do somethink like:
df.write.insertInto(ptTableName, "pt1='2018',pt2='0601'")

we have a lot of this kind of scenario in our production env. providing a api like this will make us less painful.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org