SHA3_512
Hashes the input using SHA3-512
.
Syntax
SHA3_512(input)
Arguments
Name
Type
Description
Default Value
input
string
Returns
Returns a string
value.
Examples
input
Output
'Hello SHA'
537189534fab481e27b9881191654402c0484e31b028c6b129c9cbe60db5f8f19ae4918afba788bfe99270a0a2d047f27ee7ca7b43a2e1cc68cacad0258c2f6e
Transformation job example
SQL
CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data
MAP_COLUMNS_BY_NAME
SELECT input,
SHA3_512(input) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET input = 'Hello SHA'
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 1;
Query result
input
Output
'Hello SHA'
537189534fab481e27b9881191654402c0484e31b028c6b129c9cbe60db5f8f19ae4918afba788bfe99270a0a2d047f27ee7ca7b43a2e1cc68cacad0258c2f6e
Last updated