O'Reilly logo

Getting Started with Greenplum for Big Data Analytics by Sunila Gollapudi

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required