[SPARK-29545] Implement bitwise integer aggregates bit_xor

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Kent Yao 2
• Reporter: Kent Yao 2
• Created: 22/Oct/19 07:47
• Updated: 25/Oct/19 13:20
• Resolved: 25/Oct/19 13:20

Description

As we support bit_and, bit_or now, we'd better support the related aggregate function bit_xor ahead of postgreSQL, because many other popular databases support it.

 

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbreference/bit-xor-function.html

https://dev.mysql.com/doc/refman/5.7/en/group-by-functions.html#function_bit-or

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Aggregate/BIT_XOR.htm?TocPath=SQL%20Reference%20Manual%7CSQL%20Functions%7CAggregate%20Functions%7C_____10

 

Issue Links

• is a clone of: SPARK-27879 Implement bitwise integer aggregates(BIT_AND and BIT_OR)
• links to: GitHub Pull Request #26205