Skip to content
This repository was archived by the owner on May 22, 2024. It is now read-only.

An convenient R tool for manipulating tables in PostgreSQL type databases and a wrapper of Apache MADlib.

Notifications You must be signed in to change notification settings

greenplum-db/PivotalR-archive

Folders and files

NameName
Last commit message
Last commit date

Latest commit

2a4ca27 · Mar 11, 2021
Mar 11, 2021
Mar 11, 2021
Jun 3, 2014
Nov 5, 2020
Mar 11, 2021
Nov 3, 2020
Nov 5, 2020
Oct 28, 2016
Mar 11, 2021
Nov 3, 2020
Apr 15, 2014
Nov 5, 2020
Jan 18, 2014

Repository files navigation

PivotalR

PivotalR is a package that enables users of R, the most popular open source statistical programming language and environment, to interact with Greenplum Database and the PostgreSQL for big data analytics. It does so by providing an interface to the operations on tables/views in the database. These operations are almost the same as those of data.frame. Minimal amount of data is transfered between R and the database. Thus the users of R do not need to learn SQL when they operate on the objects in the database. PivotalR also lets the user to run the functions of the open source machine learning package Apache MADlib directly from R.

  1. An Introduction to PivotalR

     vignette("pivotalr") # execute in R console to view the PDF file
    
  2. To install PivotalR:

    • Get the latest stable version from CRAN by running install.packages("PivotalR")

    • Or try out the latest development version from github by running the following code (need R >= 3.0.2):

      ## install.packages("devtools") # 'devtools' package is only available for R >= 3.0.2
      devtools::install_github("PivotalR", "greenplum-db")
      
    • Or download the source tarball directly from here, and then install the tarball

      install.packages("greenplum-db-PivotalR-xxxx.tar.gz", repos = NULL, type = "source")
      

    where "greenplum-db-PivotalR-xxxx.tar.gz" is the name of the package that you have downloaded.

  3. To get started:

About

An convenient R tool for manipulating tables in PostgreSQL type databases and a wrapper of Apache MADlib.

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages