Evaluate the similarity of two strings and return the match rate In vertica SQL

Hi DiyaShoba,

Vertica doesn't have an in-built soundex function. However you can create a UDX and use it as a function. The below github link contains .cpp code for soundex UDSF. Create a C++ UDX and use it as a function

https://github.com/sKwa/vertica/tree/master/UDx

The first step is to download the .cpp code and generate a .so file using the instructions present in the below link.

https://www.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/ExtendingVertica/C++/CompilingC++.htm

Once it is done, please run the following SQL.

CREATE LIBRARY SoundexLib AS '<.so filename>';

CREATE FUNCTION soundex AS LANGUAGE 'C++' NAME 'SoundexFactory' LIBRARY SoundexLib;

A detailed example of generating C++ User Defined Scalar Function is present in the following link

https://www.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/ExtendingVertica/UDx/ScalarFunctions/ExampleC++check_constraints.htm

Thank you,
Sruthi

Hey SruthiA,
Thanks. I will try and let you know.