String operators

String operators

The || operator performs string concatenation.

Note that when one of the operands is an array, the || operator performs array concatenation instead of string concatenation.

Examples

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 
        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
Keith Cook	Keith	Cook
Megan Murphy	Megan	Murphy
Louis Long	Louis	Long