[ https://issues.apache.org/jira/browse/SPARK-28027?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiao Li resolved SPARK-28027. ----------------------------- Resolution: Won't Fix > Missing some mathematical operators > ----------------------------------- > > Key: SPARK-28027 > URL: https://issues.apache.org/jira/browse/SPARK-28027 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Yuming Wang > Priority: Major > > ||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] -- This message was sent by Atlassian Jira (v8.3.2#803003) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org