Search found 11 matches
- Wed Mar 04, 2015 11:45 pm
- Forum: R Language Integration
- Topic: UDF Transform and Partition by
- Replies: 1
- Views: 14752
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...
- Tue May 27, 2014 2:57 pm
- Forum: Vertica User Defined Functions (UDFs)
- Topic: UDF not working with external reporting tool
- Replies: 1
- Views: 14334
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
- Wed May 21, 2014 5:27 pm
- Forum: Vertica User Defined Functions (UDFs)
- Topic: UDF not working with external reporting tool
- Replies: 1
- Views: 14334
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...
- Fri Mar 28, 2014 8:50 pm
- Forum: R Language Integration
- Topic: Transform Function Error
- Replies: 0
- Views: 14436
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...
- Fri Mar 22, 2013 7:50 pm
- Forum: Vertica SQL
- Topic: LEFT - Remove everything before the .
- Replies: 2
- Views: 9181
- Thu Mar 21, 2013 4:12 pm
- Forum: Vertica SQL
- Topic: LEFT - Remove everything before the .
- Replies: 2
- Views: 9181
LEFT - Remove everything before the .
Anyone know how this snippet would translate in to Vertica SQL . . . seems to not like CHARINDEX.
Thanks!
Code: Select all
LEFT(Column1, CHARINDEX('.', Column1) - 1)
- Tue Dec 11, 2012 4:56 pm
- Forum: Vertica SQL
- Topic: P-Value function/calculation
- Replies: 1
- Views: 5166
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!
Thanks!