Ok. Thanks it seems I have to make the Cassandra river work. On 13 Jun 2014 16:34, "joergpra...@gmail.com" <joergpra...@gmail.com> wrote:
> The Cassandra Java Driver is not a JDBC driver. > > Jörg > > > On Fri, Jun 13, 2014 at 11:11 AM, Abhishek Mukherjee <4271...@gmail.com> > wrote: > >> 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 elasticsearch+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/elasticsearch/a5dc2bf7-2380-4425-893a-a44e587ba9ce%40googlegroups.com >> <https://groups.google.com/d/msgid/elasticsearch/a5dc2bf7-2380-4425-893a-a44e587ba9ce%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "elasticsearch" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/elasticsearch/iU_JRwxl6ZI/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > elasticsearch+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGf1GjB8MSefx6ZC1OYD0b6Xf%3DKX%2BpDHcYe7cvZVmeyJg%40mail.gmail.com > <https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGf1GjB8MSefx6ZC1OYD0b6Xf%3DKX%2BpDHcYe7cvZVmeyJg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAMjqjp4RYqhCP_BwGcA08WPtsc29AFj8UB%2Boi2tyTpY%2BPZouMg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.