Hive Concat: Join Strings & Fields

1 year ago
William Carter
1 minute

In Hive, the concat() function can be used to concatenate strings and fields.

The sample code is as follows:

SELECT concat('Hello', ' ', name) AS greeting
FROM table_name;

In the example above, we concatenate the string ‘Hello’ with the name field in the table, resulting in a concatenation output similar to ‘Hello John’.

bannerAds