topic Re: Error when trying to insert data from MySQL to Cassandra in Talend Studio

Error when trying to insert data from MySQL to Cassandra

Anonymous — Sat, 16 Nov 2024 10:00:47 GMT

Hi I am trying to insert data from MySQL to Cassandra but getting below error:-

Starting job mysql_to_cassandra at 04:11 09/03/2017.

[left][statistics] connecting to socket on port 3975[/left]
[left][statistics] connected[/left]

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".

SLF4J: Defaulting to no-operation (NOP) logger implementation

SLF4J: See for further details.

Exception in component tCassandraOutput_1

[left]com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.96.145:9042 (com.datastax.driver.core.exceptions.TransportException: [/192.168.96.145] Cannot connect))[/left]

at com.datastax.driver.core.ControlConnection.reconnectInternal(ControlConnection.java:231)

at com.datastax.driver.core.ControlConnection.connect(ControlConnection.java:77)

at com.datastax.driver.core.Cluster$Manager.init(Cluster.java:1414)

at com.datastax.driver.core.Cluster.init(Cluster.java:162)

at com.datastax.driver.core.Cluster.connectAsync(Cluster.java:333)

at com.datastax.driver.core.Cluster.connectAsync(Cluster.java:308)

at com.datastax.driver.core.Cluster.connect(Cluster.java:250)

at test_project.mysql_to_cassandra_0_1.mysql_to_cassandra.tMysqlInput_1Process(mysql_to_cassandra.java:644)

at test_project.mysql_to_cassandra_0_1.mysql_to_cassandra.runJobInTOS(mysql_to_cassandra.java:1281)

at test_project.mysql_to_cassandra_0_1.mysql_to_cassandra.main(mysql_to_cassandra.java:1138)

[left][statistics] disconnected[/left]
[left]Job mysql_to_cassandra ended at 04:11 09/03/2017. [exit code=1][/left]

I am using tcassandraoutput component.

Any help would be really appreciated. Thanks in advance !!

Re: Error when trying to insert data from MySQL to Cassandra

vapukov — Thu, 09 Mar 2017 01:59:55 GMT

double check the host

(tried: /192.168.96.145:9042

look like error in host - what is it / at begin?

Re: Error when trying to insert data from MySQL to Cassandra

Anonymous — Thu, 09 Mar 2017 08:17:15 GMT

Hi,
My Talend client is installed in local machine i.e. Windows 7 and my Cassandra is installed in Ubuntu VM. I am able to ping VM IP address from windows.
9042 is the native_transport_port for cassandra.
Not sure what is / at begin ? In talend I have defined host and port in double quotes "" as per standards.
As per one given post I have
Thanks,
Mohit

Re: Error when trying to insert data from MySQL to Cassandra

vapukov — Thu, 09 Mar 2017 08:51:25 GMT

attach the pictures please, because error log show - it not as You describe

Re: Error when trying to insert data from MySQL to Cassandra

Anonymous — Thu, 09 Mar 2017 11:32:40 GMT

I have attached the pictures of talend studio.
Also, I am trying to create NoSQL connection for cassandra. It is failing and giving me error. I have pasted error in attached Connection_Error.txt.txt file.

Please let me know of anything, that would be needed to solve this issue. Thanks !!!

Re: Error when trying to insert data from MySQL to Cassandra

Anonymous — Thu, 09 Mar 2017 11:36:31 GMT

pictures

Re: Error when trying to insert data from MySQL to Cassandra

Anonymous — Thu, 09 Mar 2017 11:44:07 GMT

Pictures

Re: Error when trying to insert data from MySQL to Cassandra

vapukov — Thu, 09 Mar 2017 12:14:37 GMT

nothing attached

Re: Error when trying to insert data from MySQL to Cassandra

Anonymous — Fri, 10 Mar 2017 03:17:35 GMT

Hi,
Screenshots works only if you drag&drop the image directly in the editor window.
Best regards
Sabrina