tCassandraInput does not execute specific cql.

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