Links
Comment on page

MD5

Hashes the input using MD5

Syntax

MD5(input)

Arguments

Name
Type
Description
Default Value
input
string

Returns

string

Examples

input
Output
'hello world'
5eb63bbbe01eeed093cb22bb8f5acdc3

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,
MD5(input) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET input = 'hello world'
WHERE time_filter()
LIMIT 1;

Query result

input
Output
'hello world'
5eb63bbbe01eeed093cb22bb8f5acdc3
Last modified 3mo ago