[CALCITE-5642] Add SHA256, SHA512 functions (enabled in BigQuery and PostgreSQL libraries)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Labels: pull-request-available
• Assignee: Dan Zou
• Reporter: Dan Zou
• Created: 12/Apr/23 06:33
• Updated: 27/Jul/23 10:22
• Resolved: 25/Apr/23 08:00

Description

Add SHA256, SHA512 functions and enable them for BigQuery.

SHA256: Computes the hash of the input using the SHA-256 algorithm. This function returns 32 bytes.

SHA512: Computes the hash of the input using the SHA-512 algorithm. This function returns 64 bytes.

See more details in BigQuery Doc

Issue Links

• links to: GitHub Pull Request #3148