You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Takeshi Yamamuro (Jira)" <ji...@apache.org> on 2020/01/09 02:24:00 UTC

[jira] [Commented] (SPARK-28122) Binary String Functions: SHA functions

    [ https://issues.apache.org/jira/browse/SPARK-28122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17011317#comment-17011317 ] 

Takeshi Yamamuro commented on SPARK-28122:
------------------------------------------

[~aman_omer] You're still working on this. Since this is pg-specific, I'll close this for now. If necessary, please reopen this. Thanks!

> Binary String Functions: 	SHA functions
> ---------------------------------------
>
>                 Key: SPARK-28122
>                 URL: https://issues.apache.org/jira/browse/SPARK-28122
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Yuming Wang
>            Priority: Major
>
> ||Function||Return Type||Description||Example||Result||
> |{{sha224(}}{{bytea}}{{)}}|{{bytea}}|SHA-224 hash|{{sha224('abc')}}|{{\x23097d223405d8228642a477bda255b32aadbce4bda0b3f7e36c9da7}}|
> |{{sha256(}}{{bytea}}{{)}}|{{bytea}}|SHA-256 hash|{{sha256('abc')}}|{{\xba7816bf8f01cfea414140de5dae2223b00361a396177a9cb410ff61f20015ad}}|
> |{{sha384(}}{{bytea}}{{)}}|{{bytea}}|SHA-384 hash|{{sha384('abc')}}|{{\xcb00753f45a35e8bb5a03d699ac65007272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358baeca134c825a7}}|
> |{{sha512(}}{{bytea}}{{)}}|{{bytea}}|SHA-512 hash|{{sha512('abc')}}|{{\xddaf35a193617abacc417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a2192992a274fc1a836ba3c23a3feebbd454d4423643ce80e2a9ac94fa54ca49f}}|
> More details: https://www.postgresql.org/docs/11/functions-binarystring.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org