[ https://issues.apache.org/jira/browse/SPARK-15706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-15706: ------------------------------------ Assignee: (was: Apache Spark) > Wrong Answer when using IF NOT EXISTS in INSERT OVERWRITE for DYNAMIC > PARTITION > ------------------------------------------------------------------------------- > > Key: SPARK-15706 > URL: https://issues.apache.org/jira/browse/SPARK-15706 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.0.0 > Reporter: Xiao Li > > IF NOT EXISTS in INSERT OVERWRITE should not support dynamic partitions. > However, we returns a wrong answer. > {noformat} > CREATE TABLE table_with_partition(c1 string) > PARTITIONED by (p1 string,p2 string) > INSERT OVERWRITE TABLE table_with_partition > partition (p1='a',p2='b') > SELECT 'blarr2' > INSERT OVERWRITE TABLE table_with_partition > partition (p1='a',p2) IF NOT EXISTS > SELECT 'blarr3' > {noformat} > {noformat} > !== Correct Answer - 1 == == Spark Answer - 2 == > [blarr2,a,b] [blarr2,a,b] > ! [blarr3,a,blarr3] > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org