zhangjun0x01 opened a new issue, #1076: URL: https://github.com/apache/incubator-paimon/issues/1076
### Search before asking - [X] I searched in the [issues](https://github.com/apache/incubator-paimon/issues) and found nothing similar. ### Paimon version 0.4 ### Compute Engine flink ### Minimal reproduce step 1. we have a mysql table ,like this: ``` mysql> select * from products; +----+------+----------+-------+------+------+------------+---------------------+---------------------+ | ID | b | CREATEBY | a | c | d | e | f | g | +----+------+----------+-------+------+------+------------+---------------------+---------------------+ | 1 | aa | aa | 1.230 | bb | ccc | 2023-04-19 | 2023-04-19 12:43:11 | 2023-04-19 12:43:13 | | 2 | aa | bb | 1.230 | bb | ccc | 2023-04-19 | 2023-04-19 12:43:11 | 2023-04-19 12:43:13 | | 3 | aa | c | 2.300 | bb | ccc | 2023-04-19 | 2023-04-19 12:43:11 | 2023-04-19 12:43:13 | +----+------+----------+-------+------+------+------------+---------------------+---------------------+ 3 rows in set (0.00 sec) ``` 2. start the flink cdc action to sync the mysql data to paimon. 3. rename the mysql column a to a1 4. the paimon table will add a new column `a1`, and do not drop old column `a`. ``` Flink SQL> select * from products; +----+----+----------+-------+----+-----+------------+---------------------+---------------------+--------+ | ID | b | CREATEBY | a | c | d | e | f | g | a1 | +----+----+----------+-------+----+-----+------------+---------------------+---------------------+--------+ | 1 | aa | aa | 1.230 | bb | ccc | 2023-04-19 | 2023-04-19 12:43:11 | 2023-04-19 12:43:13 | <NULL> | | 2 | aa | bb | 1.230 | bb | ccc | 2023-04-19 | 2023-04-19 12:43:11 | 2023-04-19 12:43:13 | <NULL> | | 3 | aa | c | 2.300 | bb | ccc | 2023-04-19 | 2023-04-19 12:43:11 | 2023-04-19 12:43:13 | <NULL> | +----+----+----------+-------+----+-----+------------+---------------------+---------------------+--------+ 3 rows in set ``` ### What doesn't meet your expectations? The result does not meet expectations ### Anything else? _No response_ ### Are you willing to submit a PR? - [ ] I'm willing to submit a PR! -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
