hudi-bot opened a new issue, #17303:
URL: https://github.com/apache/hudi/issues/17303
Below MIT query fails with Hudi -
```{{{{}}{}}}
{{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 t.department = s.department
THEN
UPDATE SET *
WHEN MATCHED
AND s.operation = 'UPDATE_SALARY' THEN
UPDATE SET * ;}}
{{```}}
{{{}if we just remove `{}}}{{{}t.department = s.department{}}}{{{}` from
above query it works. It also works if we just remove reference for target
table from the same. {}}}{{{}`{}}}{{{}t.department = 'A'{}}}{{{}` doesn't work
but {}}}{{{}`s{}}}{{{}.department = 'A'{}}}{{{}` works well.{}}}
GIthub issue have reproducible code -
[https://github.com/apache/hudi/issues/12180]
Confirmed that DELTA supports these kind of MIT queries but Hudi fails with
the Exception. Also checked with master code and issue still exists.
## JIRA info
- Link: https://issues.apache.org/jira/browse/HUDI-8457
- Type: Sub-task
- Parent: https://issues.apache.org/jira/browse/HUDI-9109
- Fix version(s):
- 1.1.0
---
## Comments
05/Jan/25 23:40;daviszhang;[https://github.com/apache/hudi/issues/12180] the
issue has some initial triage;;;
---
06/Jan/25 19:08;yihua;We should mention the constraints of MATCHED
conditions as a limitation of MERGE INTO in Hudi Spark SQL, for now. We should
triage how much work it takes to actually support such matching condition.;;;
--
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]
