can't connect to Clickhouse database using apache Nifi

Question

I am trying to connect to the Clickhouse database Using Apache Nifi. I can't fix this error.

NIFI 1.12.1

StandardControllerServiceNode[service=DBCPConnectionPool[id=f73ad0c3-0176-1000-0546-94e4c6c6fe9b],
     versionedComponentId=null,
     processGroup=StandardProcessGroup[identifier=f73973ae-0176-1000-a421-ff32b5b5cb70,name=NiFi Flow], active=true] 
Failed to invoke @OnEnabled method due to java.lang.NoClassDefFoundError: 
Could not initialize class ru.yandex.clickhouse.ClickHouseDriver: 
Could not initialize class ru.yandex.clickhouse.ClickHouseDriver

Please check images

Image -1

Image -2

the error message indicates there is no class defined, have you added it in your class path ? — Yongfeng, Jan 17 '21 at 15:50
@alisalem download https://github.com/ClickHouse/clickhouse-jdbc/releases/tag/release_0.2.4 clickhouse-jdbc-0.2.4-shaded.jar 5.41 MB — Denny Crane, Jan 20 '21 at 17:20

score 1 · Answer 1 · answered Jan 17 '21 at 16:32

The error tells you that the class ru.yandex.clickhouse.ClickHouseDriver can't be found.

Ensure that you:

Have the right jar
The jar exists in the right path
The user running NiFi has permissions on the jar
You are using the correct Class name for the Driver in the jar

can't connect to Clickhouse database using apache Nifi

1 Answers1