Four Stars

Talend cassandra connection issue


I am unable to connect to Cassandra using Talend. 

Talend Version: Talend Big data - Open Studio 6.4.2

Cassandra : DSE 5.1.1 CQL Version: 3.4.4 [Enterprise Sandbox provided by DataStax]

Based on above link. I tried loading additional java libraries, still not woring.  Let know how to resolve this connection issue.

cassandra-all-3.11.0.jar /  metrics-core-3.1.0.jar / netty-all-4.1.12.Final.jar /snappy-java- / lz4-1.3.0.jar / slfj-simple-1.7.25.jar



Error Message:

[main] WARN com.datastax.driver.core.NettyUtil - Found Netty's native epoll transport, but not running on linux-based operating system. Using NIO instead.
Exception in component tCassandraInput_2
com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: localhost/ (com.datastax.driver.core.exceptions.TransportException: [localhost/] Cannot connect), localhost/0:0:0:0:0:0:0:1:9042 (com.datastax.driver.core.exceptions.TransportException: [localhost/0:0:0:0:0:0:0:1] Cannot connect))
at com.datastax.driver.core.ControlConnection.reconnectInternal(
at com.datastax.driver.core.ControlConnection.connect(
at com.datastax.driver.core.Cluster$Manager.init(
at com.datastax.driver.core.Cluster.init(
at com.datastax.driver.core.Cluster.connectAsync(
at com.datastax.driver.core.Cluster.connectAsync(
at com.datastax.driver.core.Cluster.connect(
at local_project.cassandra_01_0_1.CASSANDRA_01.tCassandraInput_2Process(
at local_project.cassandra_01_0_1.CASSANDRA_01.tLibraryLoad_1Process(
at local_project.cassandra_01_0_1.CASSANDRA_01.tLibraryLoad_5Process(
at local_project.cassandra_01_0_1.CASSANDRA_01.tLibraryLoad_3Process(
at local_project.cassandra_01_0_1.CASSANDRA_01.tLibraryLoad_2Process(
at local_project.cassandra_01_0_1.CASSANDRA_01.tLibraryLoad_4Process(
at local_project.cassandra_01_0_1.CASSANDRA_01.tLibraryLoad_8Process(
at local_project.cassandra_01_0_1.CASSANDRA_01.runJobInTOS(
at local_project.cassandra_01_0_1.CASSANDRA_01.main(
[statistics] disconnected

  • Big Data

Re: Talend cassandra connection issue


What's the error message you are getting? Is it a missing jar issue?

Can you successfully connect to Cassandra DB through client without using talend tool?

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Talend cassandra connection issue

I am able to connect to  Cassandra from client (Datastax DevCenter) screenshot attached. I believe its due to jar. Not clear with right jar to use.