Will carbon support MERGE INTO sql?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Will carbon support MERGE INTO sql?

Zhangshunyu
Hi dev,
I see carbon now support merge into api, but not support MERGE INTO sql,
take Delta Lake as an example:

MERGE INTO [db_name.]target_table [AS target_alias]
USING [db_name.]source_table [<time_travel_version>] [AS source_alias]
ON <merge_condition>
[ WHEN MATCHED [ AND <condition> ] THEN <matched_action> ]
[ WHEN MATCHED [ AND <condition> ] THEN <matched_action> ]
[ WHEN NOT MATCHED [ AND <condition> ]  THEN <not_matched_action> ]

Will carbon supprt this in future? any plan about this?



-----
My English name is Sunday
--
Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/
My English name is Sunday
Reply | Threaded
Open this post in threaded view
|

Re: Will carbon support MERGE INTO sql?

Ajantha Bhat
Hi Zhangshunyu,
Yes, we are aware of this. As API support is already there, this was a
lower priority compared to other pending works like IUD performance
improvement and new feature implementations like time travel, segment
interface refactoring.

If you are interested to contribute on SQL syntax support for merge, you
are most welcome.
Else somebody will take up this in next version may be.

Thanks,
Ajantha


On Mon, 26 Oct, 2020, 9:19 am Zhangshunyu, <[hidden email]> wrote:

> Hi dev,
> I see carbon now support merge into api, but not support MERGE INTO sql,
> take Delta Lake as an example:
>
> MERGE INTO [db_name.]target_table [AS target_alias]
> USING [db_name.]source_table [<time_travel_version>] [AS source_alias]
> ON <merge_condition>
> [ WHEN MATCHED [ AND <condition> ] THEN <matched_action> ]
> [ WHEN MATCHED [ AND <condition> ] THEN <matched_action> ]
> [ WHEN NOT MATCHED [ AND <condition> ]  THEN <not_matched_action> ]
>
> Will carbon supprt this in future? any plan about this?
>
>
>
> -----
> My English name is Sunday
> --
> Sent from:
> http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/
>