[SPARK-44983] Convert binary to string by to_char for the formats: hex, base64, utf-8

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 28/Aug/23 07:07
• Updated: 28/Aug/23 13:55
• Resolved: 28/Aug/23 13:55

Description

Map the to_char() function with a binary input to one of hex(), base64(), decode() to achieve feature parity with:

• Snowflake: https://docs.snowflake.com/en/sql-reference/functions/to_char
• SAP SQL Anywhere: https://help.sap.com/docs/SAP_SQL_Anywhere/93079d4ba8e44920ae63ffb4def91f5b/81fe51196ce21014b9c6cf43b2666698.html
• Oracle: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/TO_CHAR-number.html#GUID-00DA076D-2468-41AB-A3AC-CC78DBA0D9CB
• Vertica: https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Formatting/TO_CHAR.htm
   

Issue Links

• links to: [Github] Pull Request #42632 (MaxGekk)