[SPARK-27930] List all built-in UDFs have different names

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 03/Jun/19 12:36
• Updated: 29/Dec/19 06:54
• Resolved: 29/Dec/19 06:54

Description

This ticket list all built-in UDFs have different names: 

PostgreSQL	Spark SQL	Note
random	rand
format	format_string	Spark's format_string is based on the implementation of java.util.Formatter. Which makes some formats of PostgreSQL can not supported, such as: format_string('>>%-s<<', 'Hello')
to_hex	hex
strpos	locate/position