topic Re: tCassandraInput does not execute specific cql. in Talend Studio

tCassandraInput does not execute specific cql.

Anonymous — Sat, 13 Jan 2018 05:51:27 GMT

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.

Re: tCassandraInput does not execute specific cql.

lojdr — Sat, 13 Jan 2018 18:58:31 GMT

Hello,

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

Regards

Lojdr

Re: tCassandraInput does not execute specific cql.

Anonymous — Mon, 15 Jan 2018 13:11:42 GMT

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

Re: tCassandraInput does not execute specific cql.

lojdr — Mon, 15 Jan 2018 18:20:35 GMT

@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