[GitHub] [carbondata] ravipesala edited a comment on issue #3483: [CARBONDATA-3597] Support Merge for SCD and CCD scenarios

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[GitHub] [carbondata] ravipesala edited a comment on issue #3483: [CARBONDATA-3597] Support Merge for SCD and CCD scenarios

GitBox
ravipesala edited a comment on issue #3483: [CARBONDATA-3597] Support Merge for SCD and CCD scenarios
URL: https://github.com/apache/carbondata/pull/3483#issuecomment-559641113
 
 
   > In above given example, what if there is a "e" to be inserted?
   >
   > ```
   >         Row("a", "10", false,  0),
   >         Row("a", null, true, 1),   // a was updated and then deleted
   >         Row("b", null, true, 2),   // b was just deleted once
   >         Row("c", null, true, 3),   // c was deleted and then updated twice
   >         Row("c", "20", false, 4),
   >         Row("c", "200", false, 5),
   >         Row("e", "100", false, 6)   // new key
   > ```
   
   It will work , since it already has `whenNotMatched("B.deleted=false").insertExpr(insertMap)` . I have updated in the example as well.

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
[hidden email]


With regards,
Apache Git Services