[
https://issues.apache.org/jira/browse/CARBONDATA-3597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacky Li resolved CARBONDATA-3597.
----------------------------------
Fix Version/s: 2.0.0
Resolution: Fixed
> Support DataSet merge functionality in Carbon
> ---------------------------------------------
>
> Key: CARBONDATA-3597
> URL: https://issues.apache.org/jira/browse/CARBONDATA-3597
> Project: CarbonData
> Issue Type: New Feature
> Reporter: Ravindra Pesala
> Priority: Major
> Fix For: 2.0.0
>
> Attachments: Support DataSet Merge in CarboonData_V1.docx
>
> Time Spent: 14h 50m
> Remaining Estimate: 0h
>
> Merge dataset is essential to improve the performance of SCD and CDC
> scenarios and also it eases the development effort.
> The expected behavior as follows.
> SQL Syntax
> {code}
> MERGE INTO [db_name.]target_table [AS target_alias]
> USING [db_name.]source_table [AS source_alias]
> ON <merge_condition>
> [ WHEN MATCHED [ AND <condition> ] THEN <matched_actions> ]
> [ WHEN MATCHED [ AND <condition> ] THEN <matched_actions> ]
> [ WHEN NOT MATCHED [ AND <condition> ] THEN <not_matched_actions> ]
> {code}
>
> DataFrame API
> {code}
> targetDS.merge(sourceDS, _<condition>_).
> whenMatched(_<condition>_).
> updateExpr(updateMap).
> insertExpr(insertMap_u).
> whenNotMatched(_<condition>_).
> insertExpr(insertMap).
> whenNotMatchedAndExistsOnlyOnTarget(_<condition>_).
> delete().
> insertHistoryTableExpr(insertMap_d, <table_name>).
> execute()
> {code}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
