[
https://issues.apache.org/jira/browse/FLINK-32815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hanyu Zheng updated FLINK-32815:
--------------------------------
Description:
*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]
was:
*This is an implementation of HASHCODE_CONCEPT*
The {{hashcode()}} function generates a hash code for a given input value,
creating a unique integer that represents the value passed to the function.
*Brief change log*
* {{HASHCODE}} for Table API and SQL
*Syntax:*
{code:java}
{code}
{{HASHCODE(value)}}
*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]
> 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
>
> *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)
