Installing R packages in Vertica
Posted: Thu Jan 17, 2013 12:16 am
So I've been trying to install an R package dtw so that it will work within a query. So far with no luck. Basically I scp'd the package into the directory where the R libraries are kept, which happens to be called /opt/vertica/R/lib64/R/library. So now it's sitting in there with other libraries that do work (and came with the initial installation of R), but it doesn't work.
Now when I run my query (which wraps my R function I made around the query, as in SELECT timeSeriesClustering(blah) from Blah, etc) I get the following error:
ERROR 3399: Failure in UDx RPC call InvokeProcessPartition(): Error calling processPartition() in User Defined Object [timeSeriesClusteringFactory] at [RInterface.cpp:1006], error code: 0, message: Exception in processPartitionForR: ‘dtw’ is not a valid installed package
So question: it seems to be recognizing the package but it's not installed in a 'valid way'? Does anyone know how to install packages in Vertica in such a way that this will work?
By the way, inside my R function, it crashes at library(dtw).
Now when I run my query (which wraps my R function I made around the query, as in SELECT timeSeriesClustering(blah) from Blah, etc) I get the following error:
ERROR 3399: Failure in UDx RPC call InvokeProcessPartition(): Error calling processPartition() in User Defined Object [timeSeriesClusteringFactory] at [RInterface.cpp:1006], error code: 0, message: Exception in processPartitionForR: ‘dtw’ is not a valid installed package
So question: it seems to be recognizing the package but it's not installed in a 'valid way'? Does anyone know how to install packages in Vertica in such a way that this will work?
By the way, inside my R function, it crashes at library(dtw).