[ 
https://issues.apache.org/jira/browse/SPARK-18185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16619243#comment-16619243
 ] 

Deepanker commented on SPARK-18185:
-----------------------------------

Tested this even further and found out that it works for managed tables as 
well. But not for tables created via saveAsTable API of spark. 

As a test i did the following:
saveAsTable [Stored as ORC ] [Partitioned by arbitrary column] [Doesn't work 
for this]

Create Table like x [Using Beeline CLI] [Same properties as above table] [Works 
for this]

Create external Table like x [Using Beeline CLI] [Same properties as above 
table] [Works for this]

Is this the expected behaviour? I am using Spark 2.2 and Hive 1.1

> Should fix INSERT OVERWRITE TABLE of Datasource tables with dynamic partitions
> ------------------------------------------------------------------------------
>
>                 Key: SPARK-18185
>                 URL: https://issues.apache.org/jira/browse/SPARK-18185
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>            Reporter: Eric Liang
>            Assignee: Eric Liang
>            Priority: Major
>             Fix For: 2.1.0
>
>
> As of current 2.1, INSERT OVERWRITE with dynamic partitions against a 
> Datasource table will overwrite the entire table instead of only the updated 
> partitions as in Hive. It also doesn't respect custom partition locations.
> We should delete only the proper partitions, scan the metastore for affected 
> partitions with custom locations, and ensure that deletes/writes go to the 
> right locations for those as well.



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

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to