[jira] [Created] (HUDI-5904) Only one updating action is supported in MERGE INTO statement

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

xy created HUDI-5904:
------------------------

             Summary: 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


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)