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/

[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/
>

... [show rest of quote]