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!
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Pick up some tips and tricks with Context Variables