CONCAT
Concatenates the given arguments.
This function provides the same functionality as the SQL-standard concatenation operator (||
).
Syntax
CONCAT(STRING1, STRING2, ..., STRINGN)
Arguments
STRING
STRING
Type: string
A string to concatenate.
Returns
Type: string
The concatenation of all the STRING
arguments.
Examples
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
CONCAT(customer_firstname, ' ', customer_lastname) AS customer_fullname,
customer_firstname,
customer_lastname
FROM default_glue_catalog.upsolver_samples.orders_raw_data
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 3;
Query result
customer_fullname
customer_firstname
customer_lastname
Kathryn Kelly
Kathryn
Kelly
Adam Turner
Adam
Turner
Richard Miller
Richard
Miller
Last updated