[
https://issues.apache.org/jira/browse/HUDI-5904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HUDI-5904:
---------------------------------
Labels: pull-request-available (was: )
> Only one updating action is supported in MERGE INTO statement
> --------------------------------------------------------------
>
> Key: HUDI-5904
> URL: https://issues.apache.org/jira/browse/HUDI-5904
> Project: Apache Hudi
> Issue Type: Bug
> Components: spark-sql
> Reporter: xy
> Priority: Major
> Labels: pull-request-available
>
> spark.sql(
> s"""
> |merge into hudi_cow_pt_tbl as target
> |using (
> | select id, name, data, country, ts from inc_table
> |) source
> |on source.id = target.id
> |when matched and source.data > target.data then
> |update set target.data = source.data, target.ts = source.ts
> |when matched and source.data = 6 then
> |update set target.data = source.data, target.ts = source.ts
> |when not matched then
> |insert *
> |""".stripMargin)
>
> when we execute sql above，would forbidden.But most business need more than
> once update action in actual
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
