Cassandra with JDBC river plugin

Abhishek_Mukherjee · June 13, 2014, 8:13am

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.. 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.

Moving on I thought of using the JDBC-river at
GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch 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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/3d4228b3-0568-4a51-b42b-8bc4ca6b7e79%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Abhishek_Mukherjee · June 13, 2014, 9:11am

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..
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
.

Moving on I thought of using the JDBC-river at
GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch 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.
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.

jprante · June 13, 2014, 11:04am

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
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..
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
GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch 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.
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 the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to 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.
For more options, visit https://groups.google.com/d/optout.

Abhishek_Mukherjee · June 13, 2014, 5:45pm

Ok. Thanks it seems I have to make the Cassandra river work.
On 13 Jun 2014 16:34, "joergprante@gmail.com" 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
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..
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
GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch 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.
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+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?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+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.
For more options, visit https://groups.google.com/d/optout.