An convenient R tool for manipulating tables in PostgreSQL type databases and a wrapper of Apache MADlib.
Switch branches/tags
v0.1.15.48 v0.1.15.44 v0.1.15.42 v. v0.1.15.38 v0.1.15.36 v0.1.15.32 v0.1.15.29 v0.1.15.24 v0.1.15.22 v0.1.15.21 dev/roxygen2_doc dev/rewrite_table-operations dev/pmml_support dev/plot_lm dev/elnet_weight dev/continuous_test dev/boolean_ops dev/addNA archive/wrapper-summary archive/wrapper-factor archive/wrapper-elastic_net archive/vcov archive/update_maintainer archive/type_cast archive/testsuite archive/test_cv_improve archive/sort archive/scale archive/sample_cv_bagging archive/residuals archive/replacement archive/relevel archive/regr_output archive/predict archive/pr-preview_chg archive/operators archive/no_hardcoded_arg archive/new_improve_crossprod archive/more_hawq archive/method-extraction_replacement archive/method-Arith_Compare archive/merge-cv_sample_el archive/match.arg archive/margins archive/manual archive/madlib/decision_tree archive/madlib_arima archive/lm_glm_utilities archive/install-check archive/improve_test archive/improve_performance2 archive/improve_performance archive/improve_dim archive/improve_crossprod archive/improve_cbind archive/improve-na_action archive/improve-math archive/improve-logr_predict archive/improve-factors archive/improve-factor archive/improve-examples archive/improve-cv_sample archive/improve-cv_el archive/improve-by archive/improve-as.factor archive/hooi-pr-s3methods archive/hawq_compatibility archive/gui-shiny archive/grepl archive/glm archive/gh-pages archive/further_improve_crossprod archive/fix_formula_handling archive/fix_dummy_name_length archive/fix_bug_doc archive/fix-quote_bug archive/extract_coef archive/enable_vignette archive/enable_on_hawq1.2 archive/enable_doc_examples archive/dt_surrogates archive/date_ops archive/consistent_2.10 archive/clean_casts_to_speedup archive/by archive/bugs-fixing2 archive/bugs-fixing archive/bugfix/sort_order archive/bugfix-margins_null_handling archive/better_sql_error archive/better_maxiter_elnet archive/better_array_lm archive/as.list archive/array_support Versions/ Versions/ Versions/v0.1.18.3 Versions/v0.1.18.2 Versions/v0.1.17.3
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.


PivotalR is a package that enables users of R, the most popular open source statistical programming language and environment, to interact with Greenplum Database as well as Apache HAWQ (incubating) 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 (incubating) 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", "pivotalsoftware")
    • Or download the source tarball directly from here, and then install the tarball

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

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

  3. To get started: