[Feature Request]: Upgrade ClickHouseIO to use the latest ClickHouse Java V2 client

[BentsiLeviav]

What would you like to happen?

Description

The current ClickHouseIO implementation uses the legacy ClickHouse JDBC driver (v0.6.3), which is outdated and lacks support for modern ClickHouse features. The ClickHouse team has developed a new Java Client v2 that offers significant performance improvements, expanded feature support, and compatibility with recent ClickHouse versions.

Proposed Changes

• Migrate to ClickHouse Java Client v2 (latest: v0.9.6)
• Deprecate the JDBC usage in the connector

Issue Priority

Priority: 2 (default / most feature requests should be filed as P2)

Issue Components

• Component: Python SDK
• Component: Java SDK
• Component: Go SDK
• Component: Typescript SDK
• Component: IO connector
• Component: Beam YAML
• Component: Beam examples
• Component: Beam playground
• Component: Beam katas
• Component: Website
• Component: Infrastructure
• Component: Spark Runner
• Component: Flink Runner
• Component: Samza Runner
• Component: Twister2 Runner
• Component: Hazelcast Jet Runner
• Component: Google Cloud Dataflow Runner

[BentsiLeviav]

.take-issue

[BentsiLeviav]

.set-labels clickhouse,io,P2