You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "dalongliu (Jira)" <ji...@apache.org> on 2022/03/31 08:06:00 UTC

[jira] [Created] (FLINK-26951) Add HASH supported in SQL & Table API

dalongliu created FLINK-26951:
---------------------------------

             Summary: Add HASH supported in SQL & Table API
                 Key: FLINK-26951
                 URL: https://issues.apache.org/jira/browse/FLINK-26951
             Project: Flink
          Issue Type: Sub-task
          Components: Table SQL / API
            Reporter: dalongliu
             Fix For: 1.16.0


Returns a hash value of the arguments.

Syntax:
{code:java}
hash(expr1, ...) {code}
Arguments:
 * {{{}exprN{}}}: An expression of any type.

Returns:
An INTEGER.

Examples:
{code:java}
> SELECT hash('Flink', array(123), 2);
 -1321691492 {code}
See more:
 * [Spark|https://spark.apache.org/docs/latest/api/sql/index.html#hash]
 * [Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf]



--
This message was sent by Atlassian Jira
(v8.20.1#820001)