dinky icon indicating copy to clipboard operation
dinky copied to clipboard

[Feature][CDCSOURCE] supports computed column

Open melin opened this issue 2 years ago • 3 comments

Search before asking

  • [X] I had searched in the issues and found no similar feature requirement.

Description

支持计算列,类似如下的add column 语法:

CREATE TABLE IF NOT EXISTS user
WITH ('jdbcWriteBatchSize' = '1024')
AS TABLE mysql.`wp.*`.`user[0-9]+`
/*+ OPTIONS('server-id'='8001-8004') */
ADD COLUMN (
  `t_idx` AS COALESCE(SPLIT_INDEX(`tbl`, 'r', 1), 'default') FIRST,
  `c_id` AS `id` + 10 AFTER `id`
);

Use case

No response

Related issues

No response

Are you willing to submit a PR?

  • [ ] Yes I am willing to submit a PR!

Code of Conduct

melin avatar Sep 19 '23 04:09 melin

有实现方案吗??

Zzm0809 avatar Sep 19 '23 09:09 Zzm0809

This feature is relatively simple to implement. If you are interested, please contact the community to discuss the specific logic and contribution code.

aiwenmo avatar Sep 20 '23 06:09 aiwenmo

Hello, this issue has not been active for more than 30 days. This issue will be closed in 7 days if there is no response. If you have any questions, you can comment and reply.

你好, 这个 issue 30 天内没有活跃,7 天后将关闭,如需回复,可以评论回复。

github-actions[bot] avatar Feb 01 '24 00:02 github-actions[bot]