QUERY_STRING_TO_RECORD
Extracts data from the query string.
Syntax
QUERY_STRING_TO_RECORD(mappings, value)
Arguments
Name
Type
Description
Default Value
mappings
string
Field names
value
string
Examples
mappings
value
Output
'a,string'
'a=Hello'
{a: Hello
}
'a,string
b,string'
'a=Hello&b=World'
{a: Hello
, b: World
}
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 mappings, value,
QUERY_STRING_TO_RECORD('a,string', value) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET mappings = 'a,string',
value = 'a=Hello'
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 1;
Query result
mappings
value
Output
'a,string'
'a=Hello'
{a: Hello
}
Last updated