Links

CONCAT

Concatenates the given arguments.
This function provides the same functionality as the SQL-standard concatenation operator (||).

Syntax

CONCAT(STRING1, STRING2, ..., STRINGN)

Arguments

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 time_filter()
LIMIT 3;

Query result

customer_fullname
customer_firstname
customer_lastname
Kathryn Kelly
Kathryn
Kelly
Adam Turner
Adam
Turner
Richard Miller
Richard
Miller
Last modified 5mo ago