tCassandraInput does not execute specific cql.

Highlighted
Four Stars

tCassandraInput does not execute specific cql.

Dear talend,

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.

Eight Stars

Re: tCassandraInput does not execute specific cql.

Hello,

 

If you remove the semicolon at the end of the SQL query in Talend does it produce a different result set?

 

Regards

Lojdr

Four Stars

Re: tCassandraInput does not execute specific cql.

Hello,

Thanks for helping and no, the query does not produce a different result.
I am able to fetch this query "SELECT * FROM test1.emp".
But when i query "SELECT id FROM test1.emp", talend still displays the whole table.

regards
neerajb
Eight Stars

Re: tCassandraInput does not execute specific cql.


@neerajb wrote:
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)

 

Regards

Lojdr

 

 

 

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog