You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Alexander Pivovarov (JIRA)" <ji...@apache.org> on 2015/02/20 07:37:11 UTC
[jira] [Updated] (HIVE-9738) create SOUNDEX udf

     [ https://issues.apache.org/jira/browse/HIVE-9738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alexander Pivovarov updated HIVE-9738:
--------------------------------------
    Description: 
Soundex is an encoding used to relate similar names, but can also be used as a general purpose scheme to find word with similar phonemes.

The American Soundex System
The soundex code consist of the first letter of the name followed by three digits. These three digits are determined by dropping the letters a, e, i, o, u, h, w and y and adding three digits from the remaining letters of the name according to the table below. There are only two additional rules. (1) If two or more consecutive letters have the same code, they are coded as one letter. (2) If there are an insufficient numbers of letters to make the three digits, the remaining digits are set to zero.

Soundex Table
 1 b,f,p,v
 2 c,g,j,k,q,s,x,z
 3 d, t
 4 l
 5 m, n
 6 r

Examples:
Miller M460
Peterson P362
Peters P362
Auerbach A612
Uhrbach U612
Moskowitz M232
Moskovitz M213



> create SOUNDEX udf
> ------------------
>
>                 Key: HIVE-9738
>                 URL: https://issues.apache.org/jira/browse/HIVE-9738
>             Project: Hive
>          Issue Type: Improvement
>          Components: UDF
>            Reporter: Alexander Pivovarov
>            Assignee: Alexander Pivovarov
>
> Soundex is an encoding used to relate similar names, but can also be used as a general purpose scheme to find word with similar phonemes.
> The American Soundex System
> The soundex code consist of the first letter of the name followed by three digits. These three digits are determined by dropping the letters a, e, i, o, u, h, w and y and adding three digits from the remaining letters of the name according to the table below. There are only two additional rules. (1) If two or more consecutive letters have the same code, they are coded as one letter. (2) If there are an insufficient numbers of letters to make the three digits, the remaining digits are set to zero.
> Soundex Table
>  1 b,f,p,v
>  2 c,g,j,k,q,s,x,z
>  3 d, t
>  4 l
>  5 m, n
>  6 r
> Examples:
> Miller M460
> Peterson P362
> Peters P362
> Auerbach A612
> Uhrbach U612
> Moskowitz M232
> Moskovitz M213



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)