Availability of SOUNDEX function in vertica?

Forum|Forum|13 years ago
July 19, 2013
5 replies
25 views

Kiran_Reddy_Gun
New Participant

Hi, We really required these below mentioned functions for reporting purpose, So that i would like to know whether there is any alternate for CONTAINS function in vertica? Related Issues: And also especially i would like to know whether SOUNDEX, NEAR, Logical NOT, WEIGHT function is avail in vertica or not? For more info, i already tested with some of SQL's using REGEXP_LIKE, even though those above mentioned functions are not working, so please let me know is any feasibility to have these in vertica DB Thanks & Regards, Kiran

A

+2

Anonymous
Participating Frequently
Forum|Forum|13 years ago
July 22, 2013

Hi Kiran, You can view the full list of built-in Vertica functions here: https://my.vertica.com/docs/6.1.x/HTML/index.htm#8941.htm Of these, logical NOT is provided, but I believe the others are not. We may have an analytics add-on pack that provides some similar functionality. I'm not sure, though. Others here may comment. Also, if you happen to be attending our user conference in two weeks, you should ask our product-management folks there. Vertica does support external functions via our SDK. If you wanted to (and if you have C++, Java, or R developers in-house), you could implement these functions for yourself. Alternatively, there might be a third-party package that provides these functions for Vertica, but I'm not aware of one. Adam

Like

Kiran_Reddy_Gun
Author
New Participant
Forum|Forum|13 years ago
July 23, 2013

Hi Adam, Thanks for your reply. we have the only one way that we need to go with external functions as you mentioned. So i'll try and will come back to you if any suggestions. Regards, Kiran