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
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
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
Shall we move your topic to How-Tos-and-Best-Practices board?
sure - this is not a best practice
but of course we can relocate it
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Take a look at this video about Talend Integration with Databricks
Learn how<SPAN>to modernize your Cloud Platform for Big Data Analytics with Talend and Microsoft Azure</SPAN>