[jira] [Resolved] (SPARK-20831) Unresolved operator when INSERT OVERWRITE data source tables with IF NOT EXISTS

["Wenchen Fan (JIRA)" <ji...@apache.org>]

     [ 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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org