[
https://issues.apache.org/jira/browse/FLINK-26946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17515319#comment-17515319
]
Francesco Guardiani commented on FLINK-26946:
---------------------------------------------
Isn't this a duplicate of https://issues.apache.org/jira/browse/FLINK-12450 ?
> 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: Critical
> 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)
