I have a job in which I am trying to establish a connection to Cassandra in order to retrieve some data, but I am facing the following issue:
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
My cql-version is 3.4.5 and release-version is 4.0.0.
Does anyone could help me?
Solved! Go to Solution.
I added classes as discribed in this topic https://www.talendforge.org/forum/viewtopic.php?pid=164982 using tLibraryLoad component. I am getting this now:
Sep 04, 2018 4:49:34 PM com.datastax.driver.core.NettyUtil <clinit>
INFO: Detected shaded Netty classes in the classpath; native epoll transport will not work properly, defaulting to NIO.
Sep 04, 2018 4:49:35 PM com.datastax.driver.core.policies.DCAwareRoundRobinPolicy init
INFO: Using data-center name 'Cassandra' for DCAwareRoundRobinPolicy (if this is incorrect, please provide the correct datacenter name with DCAwareRoundRobinPolicy constructor)
Sep 04, 2018 4:49:35 PM com.datastax.driver.core.Cluster$Manager init
INFO: New Cassandra host localhost/127.0.0.1:9042 added
Does anyone know what does it means?
Same issue. Problem not solved.
The SLF4J messages are warnings concerning the logger that you can setup.
Have you checked that your job has successfully been executed? Do you have red error messages in your logs?
I am able to establish a connection to Cassandra now and retrieving a table which I want to query. I am having the following error in my log:
Exception in component tCassandraInput_1 (retrieveData)
java.lang.IllegalArgumentException: "batchlist" is not a column defined in this metadata
I am trying to do a simple select just to test the process. I attached my job:
Do you have problem when you do it in a built-in schema in your job?
According to this exception "java.lang.IllegalArgumentException: "batchlist" is not a column defined in this metadata", this happens because there is no column `batchlist` in `Cassandra-txn`, but tCassandraInput component wants to read it.
What's Cassandra version are you using?
but how is that possible? By establish a NOSqlConnection I am able to retrieve table txn with its column.
I am using clq 3.4.5 Cassandra-version 4.0.0.
We presume schemas could not be retrieved properly for Cassandra 4.0.0 on TOS 7.0.1 Big Data.
Here is online installation guide about:TalendHelpCenter: Supported systems, databases and business applications by Talend components.
Cassandra-version 4.0.0. is not list in the supported table.
Is there a way to face the issue?
I re-checked the version:
cqlsh> SELECT cql_version, release_version FROM system.local;
cql_version | release_version
3.4.5 | 188.8.131.529
I Know. Is there a way to solve the issue?
I re-checked the version:
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks