[jira] [Comment Edited] (CALCITE-5851) Add LEVENSHTEIN function (enabled in Hive and Spark library)

["Runkang He (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17743811#comment-17743811 ] 

Runkang He edited comment on CALCITE-5851 at 7/17/23 1:44 PM:
--------------------------------------------------------------

[~jhyde] The example:

{code:sql}
SELECT levenshtein('kitten', 'sitting');
> 3
{code}

The Hive's link is category level only, so we need to search it. The Spark's link can take directly to the function.


was (Author: JIRAUSER280488):
[~jhyde] The example:

{code:sql}
SELECT levenshtein('kitten', 'sitting');
> 3
{code}
 

The Hive's link is category level only, so we need to search it. The Spark's link can take directly to the function.

> Add LEVENSHTEIN function (enabled in Hive and Spark library)
> ------------------------------------------------------------
>
>                 Key: CALCITE-5851
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5851
>             Project: Calcite
>          Issue Type: New Feature
>          Components: core
>    Affects Versions: 1.34.0
>            Reporter: Runkang He
>            Priority: Major
>
> Add LEVENSHTEIN function (enabled in Hive and Spark library):
> LEVENSHTEIN(str1, str2) - Returns the Levenshtein distance between the two given strings.
> See more details in [Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf#LanguageManualUDF-StringFunctions] and [Spark|https://spark.apache.org/docs/latest/api/sql/index.html#levenshtein] doc.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)