[
https://issues.apache.org/jira/browse/CALCITE-5831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ran Tao updated CALCITE-5831:
-----------------------------
Description:
Hi, devs. I noticed that calcite support soundex for BIG_QUERY, MYSQL,
POSTGRESQL, ORACLE dialect except Spark. i think we can support it.
soundex(str) - Returns Soundex code of the string.
*Examples:*
> SELECT soundex('Miller');
M460
[https://spark.apache.org/docs/latest/api/sql/index.html#soundex]
*Note:* currently calcite soundex for BIG_QUERY, MYSQL, POSTGRESQL, ORACLE
dialect throw IllegalArgumentException when string can't be mapped. However,
spark not throw exception but return original string.
[https://github.com/apache/spark/blob/c37d7dec8aa4d703b6dac9b9d60ff25d9d5dc665/common/unsafe/src/main/java/org/apache/spark/unsafe/types/UTF8String.java#L1595]
was:
Hi, devs. I noticed that calcite support soundex for BIG_QUERY, MYSQL,
POSTGRESQL, ORACLE dialect except Spark. i think we can support it.
soundex(str) - Returns Soundex code of the string.
*Examples:*
> SELECT soundex('Miller');
M460
[https://spark.apache.org/docs/latest/api/sql/index.html#soundex]
*Note:* currently ** soundex for BIG_QUERY, MYSQL, POSTGRESQL, ORACLE dialect
throw IllegalArgumentException when string can't be mapped. However, spark not
throw exception but return original string.
https://github.com/apache/spark/blob/c37d7dec8aa4d703b6dac9b9d60ff25d9d5dc665/common/unsafe/src/main/java/org/apache/spark/unsafe/types/UTF8String.java#L1595
> Add SOUNDEX function(enabled in Spark library)
> ----------------------------------------------
>
> Key: CALCITE-5831
> URL: https://issues.apache.org/jira/browse/CALCITE-5831
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.34.0
> Reporter: Ran Tao
> Assignee: Ran Tao
> Priority: Major
> Labels: pull-request-available
>
> Hi, devs. I noticed that calcite support soundex for BIG_QUERY, MYSQL,
> POSTGRESQL, ORACLE dialect except Spark. i think we can support it.
> soundex(str) - Returns Soundex code of the string.
> *Examples:*
> > SELECT soundex('Miller');
> M460
> [https://spark.apache.org/docs/latest/api/sql/index.html#soundex]
>
> *Note:* currently calcite soundex for BIG_QUERY, MYSQL, POSTGRESQL, ORACLE
> dialect throw IllegalArgumentException when string can't be mapped. However,
> spark not throw exception but return original string.
> [https://github.com/apache/spark/blob/c37d7dec8aa4d703b6dac9b9d60ff25d9d5dc665/common/unsafe/src/main/java/org/apache/spark/unsafe/types/UTF8String.java#L1595]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
