Oracle NoSql tables are relatively new. The communication between those tables and other BigData systems and tools is under construction. There is a package (rkvstore) allowing to get access to Nosql kv data from R but this package does not allow to use tables. This paper presents a way to access R from Java and to work with table data from Nosql using the R package Rserve and shows how to generate a plot of this data.
To launch the R server just install the Rserve package:
R CMD INSTALL <path to the Rserve.tar.gz source package>
R server : gets data from a Java program and returns the result
To create and load Nosql tables refer to this post.
The main steps of the java programs are:
You can find the java source code for this blog entry here.
run java with the following class and arguments
nosql.r.RViewTablesBlog kvstore kvhost:kvport tablename fligthrangebegin fligthrangeend
use -1 for fligthrangebegin fligthrangeend to ignore flight range
add kvclient.jar from NoSql and REngine.jar, RServeEngine.jar from Rserve to the classpath
R returns an image similar to: