Checking the Elasticsearch log files I found this. No suitable driver found for jdbc:cassandra://192.168.1.103:9160/transactionlogdb at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.getConnectionForReading(SimpleRiverSource.java:133) at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.execute(SimpleRiverSource.java:271)
However I have placed all the necessary jar files for the driver in $ES_HOME/plugins/jdbc. Please advice. Kind Regards Abhishek On Friday, June 13, 2014 1:43:45 PM UTC+5:30, Abhishek Mukherjee wrote: > > Hi Everyone, > > I am trying to move data from Cassandra to Elasticsearch. Initially I > tried the cassandra-river at https://github.com/eBay/cassandra-river. > However I got timed out error which I suspect was originating from the > Hector API. I posted a question on ths thread > https://groups.google.com/forum/#!searchin/elasticsearch/cassandra/elasticsearch/4oDbkqK3GVA/W9WLK4SS2MEJ > . > > Moving on I thought of using the JDBC-river at > https://github.com/jprante/elasticsearch-river-jdbc with a java driver > for cassandra. I followed the mysql example and modified it for cassandra. > I created the river using as follows: > > curl -XPUT '192.168.1.103:9200/_river/my_jdbc_river/_meta' -d '{ > > "type" : "jdbc", > > "jdbc" : { > > "url" : "jdbc:cassandra://192.168.1.105:9160/transactionlogdb", > > > > > "cql" : "select * from > logs" > > } > > }' > > > > {"_index":"_river","_type":"my_jdbc_river","_id":"_meta","_version":1,"created":true} > > However I don't find any documents being created on the jdbc index. Am I > missing something? Any help or tips is very much appreciated. Thanks is > advance. > > Kind Regards, > Abhishek Mukherjee > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/a5dc2bf7-2380-4425-893a-a44e587ba9ce%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
