[
https://issues.apache.org/jira/browse/SPARK-20831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wenchen Fan resolved SPARK-20831.
---------------------------------
Resolution: Fixed
Fix Version/s: 2.2.0
Issue resolved by pull request 18050
[https://github.com/apache/spark/pull/18050]
> Unresolved operator when INSERT OVERWRITE data source tables with IF NOT
> EXISTS
> -------------------------------------------------------------------------------
>
> Key: SPARK-20831
> URL: https://issues.apache.org/jira/browse/SPARK-20831
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.1.1, 2.2.0
> Reporter: Xiao Li
> Assignee: Xiao Li
> Fix For: 2.2.0
>
>
> Currently, we have a bug when we specify `IF NOT EXISTS` in `INSERT
> OVERWRITE` data source tables. For example, given a query:
> {noformat}
> INSERT OVERWRITE TABLE $tableName partition (b=2, c=3) IF NOT EXISTS SELECT
> 9, 10
> {noformat}
> we will get the following error:
> {noformat}
> unresolved operator 'InsertIntoTable Relation[a#425,d#426,b#427,c#428]
> parquet, Map(b -> Some(2), c -> Some(3)), true, true;;
> 'InsertIntoTable Relation[a#425,d#426,b#427,c#428] parquet, Map(b -> Some(2),
> c -> Some(3)), true, true
> +- Project [cast(9#423 as int) AS a#429, cast(10#424 as int) AS d#430]
> +- Project [9 AS 9#423, 10 AS 10#424]
> +- OneRowRelation$
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
