[jira] [Updated] (HUDI-5940) Support predicates with target table fields in matched conditions in Spark SQL MERGE INTO

["Ethan Guo (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HUDI-5940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ethan Guo updated HUDI-5940:
----------------------------
    Fix Version/s: 0.14.0

> Support predicates with target table fields in matched conditions in Spark SQL MERGE INTO
> -----------------------------------------------------------------------------------------
>
>                 Key: HUDI-5940
>                 URL: https://issues.apache.org/jira/browse/HUDI-5940
>             Project: Apache Hudi
>          Issue Type: New Feature
>            Reporter: Ethan Guo
>            Priority: Major
>             Fix For: 0.14.0
>
>
> See [https://github.com/apache/hudi/issues/6037]
> merge into delete_error_test target 
> using (select 'wlq_new3' as name, 1 as id, 29 as age, '20210101' as dt) source on target.id = source.idwhen matched and target.age = 28 then update set age = source.age, dt = source.dt when not matched  then insert (id, age, name, dt) values (source.id, source.age, source.name, '20210102')").explain(true)
> the matched condition col is target table, it will throw cannot resolve.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)