# Cassandra with JDBC river plugin **URL:** \ **Category:** Elasticsearch\ **Created:** [June 13, 2014, 8:13am UTC](https://discuss.elastic.co/t/cassandra-with-jdbc-river-plugin/18089 "2014-06-13T08:13:45Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Abhishek\_Mukherjee](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abhishek_mukherjee/32/1477_2.png) [@Abhishek\_Mukherjee](https://discuss.elastic.co/u/Abhishek_Mukherjee)\ **Post date:** [June 13, 2014, 8:13am UTC](https://discuss.elastic.co/t/cassandra-with-jdbc-river-plugin/18089/1 "2014-06-13T08:13:45Z")
Hi Everyone, I am trying to move data from Cassandra to Elasticsearch. Initially I tried the cassandra-river at [GitHub - eBay/cassandra-river: Cassandra river for Elastic search.](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 [Redirecting to Google Groups](https://groups.google.com/forum/#!searchin/elasticsearch/cassandra/elasticsearch/4oDbkqK3GVA/W9WLK4SS2MEJ). Moving on I thought of using the JDBC-river at [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/3d4228b3-0568-4a51-b42b-8bc4ca6b7e79%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/3d4228b3-0568-4a51-b42b-8bc4ca6b7e79%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Abhishek\_Mukherjee](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abhishek_mukherjee/32/1477_2.png) [@Abhishek\_Mukherjee](https://discuss.elastic.co/u/Abhishek_Mukherjee)\ **Post date:** [June 13, 2014, 9:11am UTC](https://discuss.elastic.co/t/cassandra-with-jdbc-river-plugin/18089/2 "2014-06-13T09:11:27Z")
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 [GitHub - eBay/cassandra-river: Cassandra river for Elastic search.](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 > [Redirecting to Google Groups](https://groups.google.com/forum/#!searchin/elasticsearch/cassandra/elasticsearch/4oDbkqK3GVA/W9WLK4SS2MEJ) > . > > Moving on I thought of using the JDBC-river at > [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [June 13, 2014, 11:04am UTC](https://discuss.elastic.co/t/cassandra-with-jdbc-river-plugin/18089/3 "2014-06-13T11:04:03Z")
The Cassandra Java Driver is not a JDBC driver. Jörg On Fri, Jun 13, 2014 at 11:11 AM, Abhishek Mukherjee [4271693@gmail.com](mailto:4271693@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 [GitHub - eBay/cassandra-river: Cassandra river for Elastic search.](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/](https://groups.google.com/) > > forum/#!searchin/elasticsearch/cassandra/elasticsearch/4oDbkqK3GVA/ > > W9WLK4SS2MEJ. > > > > Moving on I thought of using the JDBC-river at > > [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@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) > [https://groups.google.com/d/msgid/elasticsearch/a5dc2bf7-2380-4425-893a-a44e587ba9ce%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Abhishek\_Mukherjee](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abhishek_mukherjee/32/1477_2.png) [@Abhishek\_Mukherjee](https://discuss.elastic.co/u/Abhishek_Mukherjee)\ **Post date:** [June 13, 2014, 5:45pm UTC](https://discuss.elastic.co/t/cassandra-with-jdbc-river-plugin/18089/4 "2014-06-13T17:45:43Z")
Ok. Thanks it seems I have to make the Cassandra river work. On 13 Jun 2014 16:34, "[joergprante@gmail.com](mailto:joergprante@gmail.com)" [joergprante@gmail.com](mailto:joergprante@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 [4271693@gmail.com](mailto:4271693@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 [GitHub - eBay/cassandra-river: Cassandra river for Elastic search.](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/](https://groups.google.com/) > > > forum/#!searchin/elasticsearch/cassandra/elasticsearch/4oDbkqK3GVA/ > > > W9WLK4SS2MEJ. > > > > > > Moving on I thought of using the JDBC-river at > > > [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@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) > > [https://groups.google.com/d/msgid/elasticsearch/a5dc2bf7-2380-4425-893a-a44e587ba9ce%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](https://groups.google.com/d/topic/elasticsearch/iU_JRwxl6ZI/unsubscribe). > To unsubscribe from this group and all its topics, send an email to > [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@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) > [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGf1GjB8MSefx6ZC1OYD0b6Xf%3DKX%2BpDHcYe7cvZVmeyJg%40mail.gmail.com?utm\_medium=email&utm\_source=footer](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](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+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAMjqjp4RYqhCP\_BwGcA08WPtsc29AFj8UB%2Boi2tyTpY%2BPZouMg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAMjqjp4RYqhCP_BwGcA08WPtsc29AFj8UB%2Boi2tyTpY%2BPZouMg%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:22am UTC](https://discuss.elastic.co/t/cassandra-with-jdbc-river-plugin/18089/5 "2017-07-06T01:22:39Z")