We are trying to connect Talend to a Hive Database, which in turn maps to a Cassandra database. When creating the underlying Cassandra database using a replication strategy of "SimpleStrategy", we are able to successfully connect to the Hive Database an in turn read and write data into our Cassandra database. However, when we create the underlying Cassandra database using a replication strategy of "NetworkTopology", Talend is still able to connect to the Hive Database, but no longer provides a listing of tables within the Hive database and as a result we are not able to read and write data to the underlying Cassandra database. Because of our environment's architecture, we have a requirement to use a replication strategy of NetworkTopology, so we would greatly appreciate your assistance in troubleshooting the issue. We have tried configuring Talend using both the native Hive jar file as wells as the custom jar file provided by DataStax; unfortunately, both jars result in the same issue. Please see the attached word document for details about the issue.
Hi,
I know this question is not in this context. But it wud be great help if any1 can answer it. I am running a job where I am loading csv files from my desktop to cassandra. So after every run I have to manually change the file path for the source. Also, there is a column in table which sud have first six characters of the filename.
Is there any way to automate this whole process? Please post some reply.
Thanx in advance.
@Pooja,
Please do not mix subjects even if remotely linked to each other.
It would be way more efficient if you were opening a new thread because people having the same issue could then find it more easily.
Now regarding your issue, what about a tfilelist (
https://help.talend.com/display/TalendComponentsReferenceGuide53EN/tFileList) in front of your job so that you can read all csv files one after the other (if they are all stored in the same place)?
Please open a new thread with more details about where are stored your csv files and what you want to do with this column storing the first six char of your filename (is this a column to be created?)
Cheers,
Elisa
I have installed trial version of Talend Open Studio for Data Integration and Datastax Cassandra. I want to access a table created in Cassandra and want to use it in my Talend Job. Please suggest if anybody has done it.
