Spark read clickhouse table, connect timed out

[selmi2]

Describe the bug

Steps to reproduce

1. download spark
2. Run server/worker
3. Run shell : spark/bin/spark-shell --packages com.clickhouse:clickhouse-jdbc:0.6.0-patch5

Expected behaviour

Spark should load the table with success

Code example

var trans = spark.read.format("jdbc").option("url", "jdbc:clickhouse://XXX.XXX.XXX.XXX:8123?connectTimeout=30000").option("dbtable", "default.transctions").option("user", "default").option("password", "default").load()

Error log

java.sql.SQLException: Connect to http://XXXX:8123 [/XXXX] failed: Connect timed out, server ClickHouseNode [uri=http://XXXX:8123/default, options={connectTimeout=30000}]@2104834579 at com.clickhouse.jdbc.SqlExceptionUtils.handle(SqlExceptionUtils.java:85)

Configuration

OpenJDK 64-Bit Server VM (build 21.0.3+9-Ubuntu-1ubuntu122.04.1, mixed mode, sharing)

Environment

• Client version:
• Language version:
• OS: Linux

ClickHouse server

• ClickHouse Server version: ClickHouse server version 24.4.1