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 07:25:00 UTC

[jira] [Created] (FLINK-26946) Add SHIFTRIGHT supported in SQL & Table API

dalongliu created FLINK-26946:
---------------------------------

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


Returns a bitwise signed integral number right shifted by {{n}} bits.

Syntax:
{code:java}
shiftright(expr, n){code}
Arguments:
 * {{{}expr{}}}: An INTEGER or BIGINT expression.

 * {{{}n{}}}: An INTEGER expression specifying the number of bits to shift.

Examples:

The result type matches {{{}expr{}}}.

When {{expr}} is negative (that is, the highest order bit is set) the result remains negative because the highest order bit is sticky. When {{n}} is negative the result is 0.

See more:
 * [Spark|https://spark.apache.org/docs/latest/api/sql/index.html#shiftright]
 * [Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf]



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