[
https://issues.apache.org/jira/browse/SPARK-36836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17419504#comment-17419504
]
Apache Spark commented on SPARK-36836:
--------------------------------------
User 'richardc-db' has created a pull request for this issue:
https://github.com/apache/spark/pull/34086
> "sha2" expression with bit_length of 224 returns incorrect results
> ------------------------------------------------------------------
>
> Key: SPARK-36836
> URL: https://issues.apache.org/jira/browse/SPARK-36836
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.4.0, 3.0.0, 3.1.0, 3.2.0
> Reporter: Richard Chen
> Priority: Major
>
> {{sha2(input, bit_length)}} returns incorrect results when {{bit_length ==
> 224}}.
>
> This bug seems to have been present since the {{sha2}} expression was
> introduced in 1.5.0.
>
> Repro in spark shell:
> {{spark.sql("SELECT sha2('abc', 224)").show()}}
>
> Spark currently returns a garbled string, consisting of invalid UTF:
> {{#\t}"4�"�B�w��U�*��你���l��}}
> The expected return value is:
> {{23097d223405d8228642a477bda255b32aadbce4bda0b3f7e36c9da7}}
>
> This appears to happen because the {{MessageDigest.digest()}} function
> appears to return bytes intended to be interpreted as a {{BigInt}} rather
> than a string. Thus, the output of {{MessageDigest.digest()}} must first be
> interpreted as a {{BigInt}} and then transformed into a hex string.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
