[CALCITE-6241] Enable a few existing functions to Spark library

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.37.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: EveyWu
• Created: 03/Feb/24 10:00
• Updated: 13 hours ago
• Resolved: 07/Feb/24 02:56

Description

Add Spark as a supported library for functions that have already been implemented for other libraries.

Spark Functions Link：https://spark.apache.org/docs/latest/api/sql/index.html

Enable function List：

• DECODE
• NVL
• IFNULL
• LEN
• LENGTH
• LPAD
• RPAD
• LTRIM
• RTRIM
• ENDSWITH
• STARTSWITH
• GREATEST
• LEAST
• TRANSLATE
• BOOL_AND
• BOOL_OR
• DATE_FROM_UNIX_DATE
• UNIX_DATE
• LEFT
• REPEAT
• RIGHT
• SPACE
• TIMESTAMP_SECONDS
• TIMESTAMP_MILLIS
• TIMESTAMP_MICROS
• UNIX_SECONDS
• UNIX_MILLIS
• UNIX_MICROS
• MD5
• SHA1
• POW

 

 

 

Issue Links

• duplicates: CALCITE-5809 Enable already available functions in Apache Spark Library
• links to: GitHub Pull Request #3669
• links to: GitHub Pull Request #3948