ad1happy2go commented on issue #12180:
URL: https://github.com/apache/hudi/issues/12180#issuecomment-2446462169
@Davis-Zhang-Onehouse Looks like currently it is not allowing to use
reference for main table under extra MATCHED conditions.
I confirmed, the query like below works fine -
```
MERGE INTO hudi_table_mor_2_partition_columns t
USING comprehensive_merge_source s
ON t.id = s.id
WHEN MATCHED
AND s.operation = 'UPDATE_DEPT_MATCH'
AND s.department = ''
THEN
UPDATE SET *
WHEN MATCHED
AND s.operation = 'UPDATE_SALARY'
AND s.salary > 0
THEN
UPDATE SET *
WHEN MATCHED
AND s.operation = 'DELETE'
THEN
DELETE
WHEN NOT MATCHED
AND s.operation = 'INSERT'
AND (
s.department = 'Engineering'
OR s.salary >= 70000
)
THEN
INSERT *
;
```
Created JIRA to track the fix -
https://issues.apache.org/jira/browse/HUDI-8457
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
