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

Name	Type	Description	Default Value
input	string

input	Output
'hello world'	`5eb63bbbe01eeed093cb22bb8f5acdc3`

input	Output
'hello world'	`5eb63bbbe01eeed093cb22bb8f5acdc3`

LTRIM

PARSE_DATETIME

Last modified 3mo ago