Running R inside SAP HANA Studio
[This article was first published on Blag's bag of rants, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
*DANGER* This is just a silly blog and shouldn’t be taken any seriously.*DANGER*
Ok…you may wonder…why is Blag writing a silly blog? Well…I’m a Developer Evangelist…and it’s my job to keep developers entertained Also…I have so free time to spare
As you all may know…SAP HANA Studio runs on top of Eclipse…which means that if we can run R on Eclipse…then we can obviously run R on SAP HANA Studio…that’s exactly what we’re going to do
As easy as it gets…follows this instructions…
- Go to Help –> Install New Software
- Put the following repository
- Choose Walware – StatET
- Once installed, your SAP HANA Studio will restart and you will need to configure R.
- Go to Windows –> Preferences.
- StatET –> Run/Debug –> R Environments –> Add (In my picture, I’m using Edit as I already add it).
- Either on the Command Line or in RStudio, install the following…
- install.packages(c(“rj”, “rj.gd”), repos=”http://download.walware.de/rj-1.1″)
- Also install RJava as well…install.packages(“RJava”)
Now…you need to start the R console…so…
- Go to the little Green Arrow button and press “R_Console”.
Once that it’s done, we can go ahead and create our R script…
- Go to File –> New Project –> R Project.
- On the created R Project, right click and select New –> R Script File.
Copy this code inside your new file…
| R_from_SAP_HANA.sql |
|---|
result<-read.table('clipboard',header=TRUE,sep=';')
result<-subset(result, !duplicated(DISTANCE))
flights<-data.frame(DISTANCE=as.numeric(result$DISTANCE))
row.names(flights)<-result$FLIGHT
d<-dist(as.matrix(flights))
hc<-hclust(d)
plot(hc)
|
Now...go to the "Modeler" perspective...open a SQL Console and write the following...
| SAP_HANA_Select.sql |
|---|
SELECT DISTINCT CITYFROM || '/' || CITYTO "FLIGHT", DISTANCE FROM SFLIGHT.SPFLI WHERE DISTANCE > 0 AND CARRID = 'SQ' |
Run it...and here's come the funny part...go to the Result tab and select all records...then press Copy Rows, so the selection gets copied into the Clipboard.
Go back to the StatET perspective and click the "Run file in R via command" button...
When you run the code...you're not going to see any response, unless there's an error...so just go to the R Graphics tab which is at the bottom where the Console window seats...expand it...and you will see a Cluster Dendogram graphic generated -;)
I told you...this was a very silly post...but at least...we never left the SAP HANA Studio -:P
See you next time!
Blag.
Developer Experience.
To leave a comment for the author, please follow the link and comment on their blog: Blag's bag of rants.
R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.