Replies: 1 comment
-
正常 这项目感觉也快烂尾了 太多bug修复不好 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
flink cdc 3.3.0 mysql to doris mysql timestamp字段默认值 0000-00-00 00:00:00,无法被doris 创建schemaEvent 解析问题
如何配置 mysql 不同步schema timestamp字段的默认值 给Doris 建表设置同样的默认值?
报错如下:
Caused by: SchemaEvolveException{applyingEvent=CreateTableEvent{tableId=test.orders, schema=columns={
order_id
INT NOT NULL,order_date
TIMESTAMP(0) NOT NULL,customer_name
VARCHAR(255) NOT NULL,price
DECIMAL(10, 5) NOT NULL,product_id
INT NOT NULL,order_status
BOOLEAN NOT NULL,ctime
TIMESTAMP_LTZ(0) NOT NULL '0000-00-00 00:00:00',name
VARCHAR(64) NOT NULL ''}, primaryKeys=order_id, options=()}, exceptionMessage='Failed to schemaChange, response: {"msg":"Error","code":1,"data":"Failed to execute sql: java.sql.SQLException: (conn=216) errCode = 2, detailMessage = date literal [0000-00-00 00:00:00] is invalid: Text '0000-00-00 00:00:00' could not be parsed: Invalid value for MonthOfYear (valid values 1 - 12): 0","count":0}', cause='org.apache.doris.flink.exception.DorisSchemaChangeException: Failed to schemaChange, response: {"msg":"Error","code":1,"data":"Failed to execute sql: java.sql.SQLException: (conn=216) errCode = 2, detailMessage = date literal [0000-00-00 00:00:00] is invalid: Text '0000-00-00 00:00:00' could not be parsed: Invalid value for MonthOfYear (valid values 1 - 12): 0","count":0}'}at org.apache.flink.cdc.connectors.doris.sink.DorisMetadataApplier.applyCreateTableEvent(DorisMetadataApplier.java:167)
Beta Was this translation helpful? Give feedback.
All reactions