In order to connect to cassandra from rstudio RJDBC library would help.
Prerequisites:
Install RJDBC library
Place cassandra-jdbc.jar library in the cassandra libraries folder.
In my environment it's placed under the path '/usr/share/dse/cassandra/lib/'
Make sure thrift protocol is enabled on the cassandra cluster
If thrift is disabled it can be enabled with following command
R Script:
Install RJDBC library
1 | install.packages("RJDBC")
|
Place cassandra-jdbc.jar library in the cassandra libraries folder.
In my environment it's placed under the path '/usr/share/dse/cassandra/lib/'
Make sure thrift protocol is enabled on the cassandra cluster
1 | nodetool statusthrift |
If thrift is disabled it can be enabled with following command
1 | nodetool enablethrift |
R Script:
1 2 3 4 | library(RJDBC) cassdrv <- JDBC("org.apache.cassandra.cql.jdbc.CassandraDriver",list.files("/usr/share/dse/cassandra/lib/",pattern="jar$",full.names=T)) casscon <- dbConnect(cassdrv, "jdbc:cassandra://localhost:9160/test") res <- dbGetQuery(casscon, "select * from emp") |
No comments:
Post a Comment