How can I use plyr and reshape2 R packages with Vertica?

Rebecca_Taft

I am trying to create an R UDF which relies on the plyr and reshape2 R packages.  Before installing these packages, my other R UDFs worked fine.  However, after running install.packages("plyr") in the R terminal, none of my R UDFs work anymore.

It seems that Rcpp is related to the problem since the dbLog contained the following two lines:
Error in loadNamespace(j <- i[[1L]], c(lib.loc, .libPaths()), versionCheck = vI[]) : 

  namespace ‘Rcpp’ 0.10.2 is already loaded, but >= 0.11.0 is required

/opt/vertica/bin/vertica-udx-R: error while loading shared libraries: libRcpp.so: cannot open shared object file: No such file or directory

Is there any way I can use plyr and reshape2 with Vertica 7.0.x?  It worked in an older version of Vertica...

[Deleted User]

Hi Rebecca, It sounds like you are trying use a version of plyr (or reshape2) that is too new for that version of Vertica. You could try installing an older version of plyr; perhaps the same version as you used with the previous version of Vertica. Alternatively, if you are an Enterprise user, you could upgrade to the newly-released Vertica 7.1. This version bundles Rcpp 0.11 so should work with the version of plyr that you are installing now. (Unfortunately, the Community release with Rcpp 0.11 has been delayed, but it's coming.) Adam

Daniel_Leybovic

Hi!


http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/ProgrammersGuide/UserDefinedFunctions/UDxR...

3. You are prompted to update each package that has an update available for it. Do NOT update:

• Rcpp

• Rinside

  You can optionally update any other packages installed with the R Language Pack. You must update any packages that you manually installed and are not compatible with R 3.0.

  The packages you selected to be updated are installed. Quit R with the command: quit()

Rebecca_Taft

Using the older versions of plyr and reshape2 worked like a charm - thanks!!

Rebecca_Taft

Thanks for your comment.  I followed these instructions, but installing the newest version of plyr automatically installs Rcpp.

Said_Montiel

Hi!

I already have Vertica 7.1 installed on the cluster, but I still can't use the latest reshape library. The RCPP library is still version 0.10.2 instead of 0.11.

Did I missed something?

PRana

Hi Said,

You are correct in noting that the Rcpp version is still 0.10.2 in Vertica 7.1. We are working towards the upgrade but ran into some roadblocks. We expect to come out with the updated version in the near future.

Thanks
Pratibha

Vadym

Rebecca, which versions of plyr and reshape2 have you installed?

 

Thank you