[ 
https://issues.apache.org/jira/browse/HUDI-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17384898#comment-17384898
 ] 

ASF GitHub Bot commented on HUDI-2139:
--------------------------------------

hudi-bot edited a comment on pull request #3230:
URL: https://github.com/apache/hudi/pull/3230#issuecomment-874605269


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "410630ca9e81fc54ca91727abbb1c7b8f7f75f30",
       "status" : "DELETED",
       "url" : 
"https://dev.azure.com/apache-hudi-ci-org/785b6ef4-2f42-4a89-8f0e-5f0d7039a0cc/_build/results?buildId=738";,
       "triggerID" : "410630ca9e81fc54ca91727abbb1c7b8f7f75f30",
       "triggerType" : "PUSH"
     }, {
       "hash" : "930f7fbc806f771d60f21073a001cdefc45f37f1",
       "status" : "DELETED",
       "url" : 
"https://dev.azure.com/apache-hudi-ci-org/785b6ef4-2f42-4a89-8f0e-5f0d7039a0cc/_build/results?buildId=741";,
       "triggerID" : "930f7fbc806f771d60f21073a001cdefc45f37f1",
       "triggerType" : "PUSH"
     }, {
       "hash" : "2568538186a80a3cea8470e01cafb654a825c75a",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "2568538186a80a3cea8470e01cafb654a825c75a",
       "triggerType" : "PUSH"
     }, {
       "hash" : "b40560674be9aafd086e569e891db6d7c26eb78a",
       "status" : "DELETED",
       "url" : 
"https://dev.azure.com/apache-hudi-ci-org/785b6ef4-2f42-4a89-8f0e-5f0d7039a0cc/_build/results?buildId=743";,
       "triggerID" : "b40560674be9aafd086e569e891db6d7c26eb78a",
       "triggerType" : "PUSH"
     }, {
       "hash" : "be436c40648b2a167c637c1ed98376a9cb15b16d",
       "status" : "DELETED",
       "url" : 
"https://dev.azure.com/apache-hudi-ci-org/785b6ef4-2f42-4a89-8f0e-5f0d7039a0cc/_build/results?buildId=1052";,
       "triggerID" : "be436c40648b2a167c637c1ed98376a9cb15b16d",
       "triggerType" : "PUSH"
     }, {
       "hash" : "2b6219dd1b9a223dcff9e37548a14e5e1dad9813",
       "status" : "FAILURE",
       "url" : 
"https://dev.azure.com/apache-hudi-ci-org/785b6ef4-2f42-4a89-8f0e-5f0d7039a0cc/_build/results?buildId=1065";,
       "triggerID" : "2b6219dd1b9a223dcff9e37548a14e5e1dad9813",
       "triggerType" : "PUSH"
     }, {
       "hash" : "c5b3498695c86f4c689147ff6dc7469568569ac9",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "c5b3498695c86f4c689147ff6dc7469568569ac9",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * 2568538186a80a3cea8470e01cafb654a825c75a UNKNOWN
   * 2b6219dd1b9a223dcff9e37548a14e5e1dad9813 Azure: 
[FAILURE](https://dev.azure.com/apache-hudi-ci-org/785b6ef4-2f42-4a89-8f0e-5f0d7039a0cc/_build/results?buildId=1065)
 
   * c5b3498695c86f4c689147ff6dc7469568569ac9 UNKNOWN
   
   <details>
   <summary>Bot commands</summary>
     @hudi-bot supports the following commands:
   
    - `@hudi-bot run travis` re-run the last Travis build
    - `@hudi-bot run azure` re-run the last Azure build
   </details>


-- 
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: commits-unsubscr...@hudi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


> MergeInto MOR Table May Result InCorrect Result
> -----------------------------------------------
>
>                 Key: HUDI-2139
>                 URL: https://issues.apache.org/jira/browse/HUDI-2139
>             Project: Apache Hudi
>          Issue Type: Bug
>          Components: Spark Integration
>            Reporter: pengzhiwei
>            Assignee: pengzhiwei
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 0.9.0
>
>
> Currently we process all the update-action and inert-action in the 
> ExpressionPayload#
> getInsertValue without know whether the record is matched or not matched for 
> MOR table. This may result in incorrect merge result. e.g.
> {code:java}
> Merge into h0
> using (select 2 as id, 'a1' as name, 10 as price from s) s0
> on h0.id = s0.id
> when matched then s0.id = 1 the update set id = s0.id, name = s0.name, price 
> = 10
> when not matched then s0.id = 2 the insert (id,name,price) values(id,name, 
> 20){code}
> If the id = 2 can matched the target table h0,  but it cannot match the 
> udpate-condition ( s0.id = 1),  It should not update the table. However, 
> currently we cannot know the matched state of the input record, it will goes 
> to the not-matched actions and update the price to 20 finally. This is 
> incorrect.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to