[ https://issues.apache.org/jira/browse/HIVE-9738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14328830#comment-14328830 ]
Hive QA commented on HIVE-9738: ------------------------------- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12699830/HIVE-9738.1.patch {color:green}SUCCESS:{color} +1 7570 tests passed Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2832/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2832/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2832/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12699830 - PreCommit-HIVE-TRUNK-Build > 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 > Attachments: HIVE-9738.1.patch > > > 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 > Implementation: > http://commons.apache.org/proper/commons-codec/apidocs/org/apache/commons/codec/language/Soundex.html -- This message was sent by Atlassian JIRA (v6.3.4#6332)