[SPARK-20746] Built-in SQL Function Improvement

• Type: Umbrella
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Xiao Li
• Created: 15/May/17 22:19
• Updated: 07/Feb/18 07:36
• Resolved: 31/Jan/18 18:01

Description

SQL functions are part of the core of the ISO/ANSI standards. This umbrella JIRA is trying to list all the ISO/ANS SQL functions that are not fully implemented by Spark SQL, fix the documentation and test case issues in the supported functions.

Issue Links

• links to: [Github] Pull Request #18046 (kiszk)

Sub-Tasks

• Built-in SQL Function Support - CH[A]R: Resolved
• Built-in SQL Function Support - all variants of LEN[GTH]: Resolved
• Built-in SQL Function Support - REPLACE: Resolved
• Built-in SQL Function Support - COT: Resolved
• Add Function Alias For MOD/TRUNCT/POSITION: Resolved
• Build-in SQL Function Support - DAYOFWEEK: Resolved
• Build-in SQL Function Support - UUID: Resolved
• Built-in SQL Function ABS support string type: Resolved
• Built-in SQL Function UnaryMinus/UnaryPositive support string type: Resolved
• Built-in SQL Function FormatNumber should validate input value: Resolved
• pmod(number, 0) should be null: Resolved
• Add incompatible Hive UDF describe to DOC: Resolved
• ACOS(2) and ASIN(2) should be null: Resolved
• Support Trim characters in the string trim function: Resolved
• Add SQL function - RIGHT && LEFT: Resolved
• Add new built-in function date_trunc(): Resolved
• Add function alias for Bitwise functions: Resolved