Google Bigquery : Concatenate values from two Columns

Problem 🔍

When trying to concatenate values from two columns in Bigquery, It throws the below error message:

Select  Column1 + '.' + Column2;

Error: No matching signature for operator + for argument types: STRING, STRING. 
Supported signatures: INT64 + INT64; FLOAT64 + FLOAT64; NUMERIC + NUMERIC at [3]

Solution 💡

To Concatenate two strings in Bigquery use the CONCAT function:

CONCAT(Column1,'.',Column2)

Make sure all the columns or expression used within the CONCAT function are of STRING Datatype

DataFreak

posted on 27 Feb 19