Talend problem with tInput components using schema (tCassandraInput, tPostgreSQLInput)

Highlighted
Forteen Stars

Talend problem with tInput components using schema (tCassandraInput, tPostgreSQLInput)

May be it is well knowing issue, but I found just last week

 

tPostgreSQL and tCassandraInput do not affected by Schema (column family name) in component/connection settings

 

I never meet this before, because:

- in my environment both primary used as target database

- and for input I always use in query schema name

 

but when make tests, I found - both return error unless You not include schema name (column family name) in query text

Screen Shot 2018-06-26 at 11.41.29.png

 

Exception in component tCassandraInput_1 (DEMO_BigDataCassandra)
com.datastax.driver.core.exceptions.InvalidQueryException: No keyspace has been specified. USE a keyspace, or explicitly specify keyspace.tablename
	at com.datastax.driver.core.exceptions.InvalidQueryException.copy(InvalidQueryException.java:50)
	at com.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37)
	at com.datastax.driver.core.DefaultResultSetFuture.getUninterruptibly(DefaultResultSetFuture.java:245)

key space correct, if add it to query text - all start work (same with PostgreSQL)

P.S. there are nothing to ask - just need manually add schema/family name into SQL code
message just informative

-----------
Moderator

Re: Talend problem with tInput components using schema (tCassandraInput, tPostgreSQLInput)

Hello,

We don't find a related jira issue on talend bug tracker.

Here exists a jira issue about cassandra metadata doesn't support for data viewer and it has been fixed on 6.1.2, 6.2.1

https://jira.talendforge.org/browse/TBD-3086

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Forteen Stars

Re: Talend problem with tInput components using schema (tCassandraInput, tPostgreSQLInput)

Hi Sabrina,

sure - because I publish it here, tested on 6.4, 6.5, 7.01

it not a question, just information about problem and by-pass

-----------
Moderator

Re: Talend problem with tInput components using schema (tCassandraInput, tPostgreSQLInput)

Hello,

Shall we move your topic to How-Tos-and-Best-Practices board?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Forteen Stars

Re: Talend problem with tInput components using schema (tCassandraInput, tPostgreSQLInput)

sure - this is not a best practice Smiley Happy
but of course we can relocate it

-----------

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog