This should work: ``` ALTER TABLE `table` ADD PARTITION (partcol=1) LOCATION '/path/to/your/dataset' ```
On Wed, Jul 19, 2017 at 6:13 PM, ctang <ctang...@gmail.com> wrote: > I wonder if there are any easy ways (or APIs) to insert a dataframe (or > DataSet), which does not contain the partition columns, as a static > partition to the table. For example, > The DataSet with columns (col1, col2) will be inserted into a table (col1, > col2) partitioned by column partcol as a static partition with partspec > (partcol =1). > > Thanks > > > > -- > View this message in context: http://apache-spark-user-list. > 1001560.n3.nabble.com/How-to-insert-a-dataframe-as-a- > static-partition-to-a-partitioned-table-tp28882.html > Sent from the Apache Spark User List mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe e-mail: user-unsubscr...@spark.apache.org > >
