Search found 11 matches

by stwp86
Wed Mar 04, 2015 11:45 pm
Forum: R Language Integration
Topic: UDF Transform and Partition by
Replies: 1
Views: 1722

UDF Transform and Partition by

Any thoughts on this error? Error: [Vertica][VJDBC](100081) ERROR: Failure in UDx RPC call InvokeProcessPartition(): Error calling processPartition() in User Defined Object [function_name] at [/scratch_a/release/30493/vbuild/vertica/OSS/UDxFence/RInterface.cpp:1321], error code: 0, message: Exceptio...
by stwp86
Tue May 27, 2014 2:57 pm
Forum: Vertica User Defined Functions (UDFs)
Topic: UDF not working with external reporting tool
Replies: 1
Views: 1578

Re: UDF not working with external reporting tool

Just needed to put in a fully qualified reference to the UDF, so test.TEST.UDF_Name
by stwp86
Wed May 21, 2014 5:27 pm
Forum: Vertica User Defined Functions (UDFs)
Topic: UDF not working with external reporting tool
Replies: 1
Views: 1578

UDF not working with external reporting tool

Hi all . . . I am using Report Builder on top of my Vertica DB, works well. But recently developed some UDF's using R, and now when I try to call them in Report Builder I am getting an error to the tune of : ERROR: Function does not exist, or permission is denied Hint: no function matches given name...
by stwp86
Fri Mar 28, 2014 8:50 pm
Forum: R Language Integration
Topic: Transform Function Error
Replies: 0
Views: 1927

Transform Function Error

Hi Everyone . . . I am new to the world of UDF w/R and Vertica. I have the following R code: betaFunction <- function(client, domain, user_name, ptSeen, avgATPP, avgOTPP, avgDTPP, percentCPOE, percentEDOC) { sub <- subset((percentEDOC > .2) & (percentCPOE > .2) & (avgATPP < .06), select=c(client, do...
by stwp86
Fri Mar 22, 2013 7:50 pm
Forum: Vertica SQL
Topic: LEFT - Remove everything before the .
Replies: 2
Views: 2393

Re: LEFT - Remove everything before the .

Thank you!

I also came across this method . . .

Code: Select all

split_part(column1, '.', 1)
by stwp86
Thu Mar 21, 2013 4:12 pm
Forum: Vertica SQL
Topic: LEFT - Remove everything before the .
Replies: 2
Views: 2393

LEFT - Remove everything before the .

Anyone know how this snippet would translate in to Vertica SQL . . . seems to not like CHARINDEX.

Code: Select all

LEFT(Column1, CHARINDEX('.', Column1) - 1)
Thanks!
by stwp86
Tue Dec 11, 2012 4:56 pm
Forum: Vertica SQL
Topic: P-Value function/calculation
Replies: 1
Views: 1179

P-Value function/calculation

Anyone know if there is an analytic function (or other function/calculation) to calculate the p-value for a set of data?

Thanks!

Go to advanced search