Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support MySQL Polygon #819

Open
poweroftrue opened this issue Sep 17, 2024 · 1 comment
Open

Support MySQL Polygon #819

poweroftrue opened this issue Sep 17, 2024 · 1 comment
Labels
dev-complete Development completed lightweight Issues related to Lightweight version

Comments

@poweroftrue
Copy link

Hello there,

This already implemented but have the following breaking issues:

  1. Nullable(polygon) if source DB has the Polygon null will throw an error: java.sql.SQLException: Code: 43. DB::Exception: Nested type Polygon cannot be inside Nullable type. (ILLEGAL_TYPE_OF_ARGUMENT) (version 24.7.1.1).
  2. If 1 is fixed manually still data won't get inserted:

java.lang.ClassCastException: class [B cannot be cast to class java.nio.ByteBuffer ([B and java.nio.ByteBuffer are in module java.base of loader 'bootstrap')
    at com.altinity.clickhouse.sink.connector.converters.ClickHouseDataTypeMapper.convert(ClickHouseDataTypeMapper.java:233) ~[app.jar:?]
    at com.altinity.clickhouse.sink.connector.db.batch.PreparedStatementExecutor.insertPreparedStatement(PreparedStatementExecutor.java:280) ~[app.jar:?]
    at com.altinity.clickhouse.sink.connector.db.batch.PreparedStatementExecutor.lambda$executePreparedStatement$0(PreparedStatementExecutor.java:143) ~[app.jar:?]
    at java.lang.Iterable.forEach(Iterable.java:75) [?:?]
    at com.altin
  1. If 2 is fixed manually still the current implementation tries to store Polygon as HEX in a Clickhouse String, while maybe there's a use case for this, I believe the best way is to store it as Clickhouse Polygon for advance analytics in Clickhouse.

I will fix these issues and PR it today.

@poweroftrue
Copy link
Author

Related partially #79

@subkanthi subkanthi added dev-complete Development completed lightweight Issues related to Lightweight version labels Sep 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
dev-complete Development completed lightweight Issues related to Lightweight version
Projects
None yet
Development

No branches or pull requests

2 participants