[SPARK-28027] Missing some mathematical operators

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 12/Jun/19 13:54
• Updated: 29/Dec/19 09:43
• Resolved: 12/Sep/19 23:39

Description

Operator	Description	Example	Result
^	exponentiation (associates left to right)	2.0 ^ 3.0	8
|/	square root	|/ 25.0	5
||/	cube root	||/ 27.0	3
!	factorial	5 !	120
!!	factorial (prefix operator)	!! 5	120
@	absolute value	@ -5.0	5
#	bitwise XOR	17 # 5	20
<<	bitwise shift left	1 << 4	16
>>	bitwise shift right	8 >> 2	2

 
Please note that we have ^, ! and !!, but it has different meanings.

https://www.postgresql.org/docs/11/functions-math.html
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/LanguageElements/Operators/BitwiseOperators.htm
https://docs.aws.amazon.com/redshift/latest/dg/r_OPERATOR_SYMBOLS.html

Issue Links

• is related to: SPARK-28007 Caret operator (^) means bitwise XOR in Spark/Hive and exponentiation in Postgres/Redshift
• links to: GitHub Pull Request #24852