The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Availability of SOUNDEX function in vertica?

Kiran_Reddy_GunKiran_Reddy_Gun
in General Discussion
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

Comments

  • [Deleted User][Deleted User]
    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
  • Kiran_Reddy_GunKiran_Reddy_Gun
    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
  • SiddarthSiddarth
    Hi Kiran,

    Were you able to implement Soundex function in Vertica?
  • SiddarthSiddarth
    Hi Kiran,

    Were you able to implement Soundex function in Vertica?
  • Daniel_LeybovicDaniel_Leybovic
    Hi.

    I wrote an UDF C++: http://vertica-forums.com/viewtopic.php?f=80&t=1492

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...