[
https://issues.apache.org/jira/browse/SPARK-44983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Max Gekk resolved SPARK-44983.
------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
Issue resolved by pull request 42632
[https://github.com/apache/spark/pull/42632]
> Convert binary to string by to_char for the formats: hex, base64, utf-8
> -----------------------------------------------------------------------
>
> Key: SPARK-44983
> URL: https://issues.apache.org/jira/browse/SPARK-44983
> Project: Spark
> Issue Type: New Feature
> Components: SQL
> Affects Versions: 4.0.0
> Reporter: Max Gekk
> Assignee: Max Gekk
> Priority: Major
> Fix For: 4.0.0
>
>
> 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
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
