I am working on a project and i chose to work with Talend Open Studio for Big Data. My project consist of using Cassandra database for data persistency. Even though I am new to it, I intend to use Talend to insert and retrieve data into Cassandra.
I was able to use the tCassandraOutput well and the result was promising.
But I have a major problem with the tCassandraInput component. It does not execute the proper cql. Hence i am not getting the required result.
If I want to retrieve the id, Talend returns the whole column.
I uploaded a screenshot of the job.
I need some help in regard of the tCassandraInput component.
Thank you in advance.
If you remove the semicolon at the end of the SQL query in Talend does it produce a different result set?
But when i query "SELECT id FROM test1.emp", talend still displays the whole table.
If "SELECT id FROM test1.emp" displays whole table it is expected behavior.
Can you please post here structure of your table? (command DESCRIBE)