prclin commented on PR #9471: URL: https://github.com/apache/seatunnel/pull/9471#issuecomment-2989956103
and there is an another promblem; case some source like mysql,it`s datetime type has precision， like datetime(3)\datetime(6)； but starrocks does not support precision, its datetime natural support the max precision [can be seen here](https://docs.starrocks.io/docs/sql-reference/data-types/date-types/DATETIME/);when schema evolution for datetime column,such as modify datetime to datetime(6), starrocks it will cause: ```txt Caused by: org.apache.seatunnel.api.table.catalog.exception.CatalogException: ErrorCode:[API-03], ErrorDescription:[Catalog initialize failed] - Failed connecting to jdbc:mysql://xxx:9030/ via JDBC. at org.apache.seatunnel.connectors.seatunnel.starrocks.sink.StarRocksSinkWriter.applySchemaChange(StarRocksSinkWriter.java:101) at org.apache.seatunnel.api.sink.multitablesink.MultiTableSinkWriter.applySchemaChange(MultiTableSinkWriter.java:163) at org.apache.seatunnel.engine.server.task.flow.SinkFlowLifeCycle.received(SinkFlowLifeCycle.java:258) ... 17 more Caused by: java.sql.SQLSyntaxErrorException: Unexpected exception: Nothing is changed. please check your alter stmt. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) at org.apache.seatunnel.connectors.seatunnel.starrocks.util.SchemaUtils.applySchemaChange(SchemaUtils.java:199) at org.apache.seatunnel.connectors.seatunnel.starrocks.util.SchemaUtils.applySchemaChange(SchemaUtils.java:86) at org.apache.seatunnel.connectors.seatunnel.starrocks.util.SchemaUtils.applySchemaChange(SchemaUtils.java:63) at org.apache.seatunnel.connectors.seatunnel.starrocks.sink.StarRocksSinkWriter.applySchemaChange(StarRocksSinkWriter.java:98) ``` it means nothing changed to this column, so how can filter these event -- 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]
