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