Skip to content

Instantly share code, notes, and snippets.

@pranasblk

pranasblk/Ignite.R

Created August 30, 2017 06:43
Show Gist options
  • Save pranasblk/f88c12da08e6637ae96927bbd10f5fb1 to your computer and use it in GitHub Desktop.
Save pranasblk/f88c12da08e6637ae96927bbd10f5fb1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Ignite.R
if (!require("RJDBC")) {
install.packages("RJDBC",repos="http://cran.rstudio.com/")
library("RJDBC")
}
jdbcDriver <- JDBC("org.apache.ignite.IgniteJdbcThinDriver",
"/Users/pranas/Apps/apache-ignite-fabric-2.1.0-bin/libs/ignite-core-2.1.0.jar:/Users/pranas/Apps/apache-ignite-fabric-2.1.0-bin/libs/log4j-1.2.17.jar")
conn <- dbConnect(jdbcDriver, "jdbc:ignite:thin://localhost")
dbGetQuery(conn, "SELECT * FROM OHLC Oder WHERE SECURITYID = 100")
dbDisconnect(conn)
@pranasblk
Copy link
Author

Looks like some meta-data mismatch:

> if (!require("RJDBC")) {
+   install.packages("RJDBC",repos="http://cran.rstudio.com/")
+   library("RJDBC")
+ }
> jdbcDriver <- JDBC("org.apache.ignite.IgniteJdbcThinDriver",
+             "/Users/pranas/Apps/apache-ignite-fabric-2.1.0-bin/libs/ignite-core-2.1.0.jar:/Users/pranas/Apps/apache-ignite-fabric-2.1.0-bin/libs/log4j-1.2.17.jar")
> conn <- dbConnect(jdbcDriver, "jdbc:ignite:thin://localhost")
> dbGetQuery(conn, "SELECT * FROM OHLC Oder WHERE SECURITYID = 100")
Error in .jcall(rp, "I", "fetch", stride, block) : 
  java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Double
> dbDisconnect(conn)
[1] TRUE

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment