corgy-w commented on PR #9471: URL: https://github.com/apache/seatunnel/pull/9471#issuecomment-2994704975
> 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: > > ``` > 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;any hints? @corgy-w I remember that the version has restrictions, so I can check it out, it seems that the subsequent version supports it -- 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: commits-unsubscr...@seatunnel.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
