[jira] [Commented] (CALCITE-5851) Add LEVENSHTEIN function (enabled in Hive and Spark library)
[ https://issues.apache.org/jira/browse/CALCITE-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17750269#comment-17750269 ] xiong duan commented on CALCITE-5851: - Fixed in [132cc3df5|https://github.com/apache/calcite/commit/132cc3df5c3248840e175bc6687718304177a91d]. Thanks for the contribution [~Runking]. Thanks for the review [~tanclary] > 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 >Assignee: Runkang He >Priority: Major > Labels: pull-request-available > Fix For: 1.36.0 > > > 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. > For more about Levenshtein distance, see > [wikipedia|https://en.wikipedia.org/wiki/Levenshtein_distance]. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (CALCITE-5851) Add LEVENSHTEIN function (enabled in Hive and Spark library)
[ https://issues.apache.org/jira/browse/CALCITE-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17744263#comment-17744263 ] Julian Hyde commented on CALCITE-5851: -- My bad. The spark link works correctly in Jira. It failed for me in email, due to markup. Thanks for adding the example. > 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 >Assignee: 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)
[jira] [Commented] (CALCITE-5851) Add LEVENSHTEIN function (enabled in Hive and Spark library)
[
https://issues.apache.org/jira/browse/CALCITE-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17743811#comment-17743811
]
Runkang He commented on CALCITE-5851:
-
[~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)
[jira] [Commented] (CALCITE-5851) Add LEVENSHTEIN function (enabled in Hive and Spark library)
[ https://issues.apache.org/jira/browse/CALCITE-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17743542#comment-17743542 ] Julian Hyde commented on CALCITE-5851: -- Since neither of those links take me (directly) to the function can you include an example. > 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)
