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

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

vapukov — Sat, 16 Nov 2024 08:02:33 GMT

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

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

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

Anonymous — Thu, 28 Jun 2018 08:49:48 GMT

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

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

vapukov — Thu, 28 Jun 2018 08:51:50 GMT

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

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

Anonymous — Thu, 28 Jun 2018 08:55:16 GMT

Hello,

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

Best regards

Sabrina

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

vapukov — Thu, 28 Jun 2018 08:56:07 GMT

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