[
https://issues.apache.org/jira/browse/FLINK-32815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752313#comment-17752313
]
Timo Walther commented on FLINK-32815:
--------------------------------------
>From all links in the description, only the Oracle one
>(https://docs.oracle.com/cd/B14117_01/server.101/b10759/functions097.htm) is
>similar to the hashcode function proposed here. MD5 or FARM are standadized
>algorithms that are save to expose publicly. However, the proposed hashcode
>function uses internal hash logic for our data structures. And we might change
>the hash logic at any point in time. Therefore, I would make this function an
>internal function. The sole purpose for now should be to speed up other
>built-in functions.
> Add HASHCODE support in SQL & Table API
> ---------------------------------------
>
> Key: FLINK-32815
> URL: https://issues.apache.org/jira/browse/FLINK-32815
> Project: Flink
> Issue Type: Improvement
> Reporter: Hanyu Zheng
> Priority: Major
> Labels: pull-request-available
>
> *This is an implementation of HASHCODE function*
> The {{hashcode}} function generates a hash code for a given input value,
> including support for computing hash values of binary data types. It creates
> a unique integer that represents the value passed to the function.
> *Brief change log*
> * {{HASHCODE}} for Table API and SQL
> *Syntax:*
> {code:java}
> HASHCODE(value){code}
>
> *Arguments:*
> * value: the value to be hashed.
> *Returns:* The function returns a unique integer representing the hash code
> of the value. If the input argument is NULL, the function returns NULL.
> *Examples:*
> {code:java}
> Flink SQL> SELECT hashcode('foo'); 12345678{code}
> *see also:*
> Java:
> [https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#hashCode--]
> Python: [https://docs.python.org/3/library/functions.html#hash]
> C#: [https://docs.microsoft.com/en-us/dotnet/api/system.object.gethashcode]
> SQL Server:
> [https://docs.microsoft.com/en-us/sql/t-sql/functions/checksum-transact-sql]
> MySQL:
> [https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_md5]
> PostgreSQL: [https://www.postgresql.org/docs/current/pgcrypto-hash.html]
> Oracle:
> [https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ORA-HASH.html]
> Google Cloud BigQuery:
> [https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#farm_fingerprint]
> AWS Redshift: [https://docs.aws.amazon.com/redshift/latest/dg/MD5.html]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
