Using R with Greenplum
In Chapter 3, Advanced Analytics – Paradigms, Tools, and Techniques, we were introduced to R programming. R is a very powerful programming language that has many built-in libraries for running statistical and analytical calculation or modeling. In this section, we will learn how R functions can be integrated to work with data in Greenplum. There are many ways in which we can run R on the data from Greenplum and we will now discuss on the following two important approaches:
- R with standard DBI connector to Greenplum; in this case, R program connects to Postgres/Greenplum database, loads data into R client
- PL/R—procedural language for SQL calls to R functions
DBI Connector for R
From R program, we can access Postgres or Greenplum ...
Get Getting Started with Greenplum for Big Data Analytics now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
