[
https://issues.apache.org/jira/browse/FLINK-26946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Martijn Visser updated FLINK-26946:
-----------------------------------
Priority: Major (was: Critical)
> 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
> Priority: Major
> 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.7#820007)
