tCassandraInput does not execute specific cql.

[Anonymous]

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.

[lojdr]

Hello,

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

Regards

Lojdr

[Anonymous]

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

[lojdr]

---

@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