We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Is the R language function only available for Enterprise customers? — Vertica Forum

Is the R language function only available for Enterprise customers?

I want to call a customized R function in Vertica instead of getting data from Vertica using ODBC and then running an R function on my local machine. For example, I have some R codes to do wavelet transform for a given vector and want to apply this function to millions of vectors in Vertica.  Can anyone point me to something useful?

Comments

  • You can write R functions for Vertica using the Enterprise or CE editions. Documentation about downloading and installing the UDX software is here:  http://my.vertica.com/docs/CE/6.0.0-1...  The Vertica documentation also includes an R example at this location:  http://my.vertica.com/docs/CE/6.0.0-1...
  • also get examples when you install the Vertica R RPM under /opt/vertica/sdk/examples
  • i am getting[dbadmin@vertica examples]$ vsql -f RFunctions.sql
    Password:
    vsql:RFunctions.sql:11: ROLLBACK 3399:  Failure in UDx RPC call InvokeSetExecContext(): Error calling setupExecContext() in User Defined Object [] at [/scratch_a/release/vbuild/vertica/OSS/UDxFence/vertica-udx-C++.cpp:180], error code: 0, message: Error happened in dlopen(): [/opt/vertica/sdk/examples/RFunctions/RFunctions.R: invalid ELF header]
    vsql:RFunctions.sql:11: ERROR 4856:  Syntax error at or near "LANGUAGE" at character 1
    vsql:RFunctions.sql:11: LINE 1: LANGUAGE 'R';
    vsql:RFunctions.sql:11:         ^
    vsql:RFunctions.sql:15: ROLLBACK 3861:  Library not found: rlib
    vsql:RFunctions.sql:18: ROLLBACK 3861:  Library not found: rlib
    CREATE TABLE
    vsql:RFunctions.sql:33: ERROR 3457:  Function Rmul(float, float) does not exist, or permission is denied for Rmul(float, float)
    HINT:  No function matches the given name and argument types. You may need to add explicit type casts
    DROP TABLE
    CREATE TABLE
    vsql:RFunctions.sql:53: ERROR 3457:  Function Kmeans(float, float) does not exist, or permission is denied for Kmeans(float, float)
    HINT:  No function matches the given name and argument types. You may need to add explicit type casts
    DROP TABLE
    vsql:RFunctions.sql:59: ROLLBACK 3855:  Library "rLib" does not exist
     an error when using R functions under /opt/vertica/sdk/examples


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file