The CONCAT function in Apache Hive incorporates two or more strings into a single string. This function’s behavior is the same as in relational database
Tag: Concatenating strings in Apache Hive
Concatenating Rows in Apache Hive
The CONCAT_WS function in Apache Hive incorporates two or more strings into a single string with the specified delimiter. Example: SELECT fname, lname, CONCAT_WS(‘ ‘,
Big Data & SQL 