[
https://issues.apache.org/jira/browse/HUDI-5940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ethan Guo updated HUDI-5940:
----------------------------
Description:
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.
> 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
>
> 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)
