How does CONCAT function work in Hive?

Hive provides CONCAT function to concatenate the input strings. We can specify multiple strings in a comma-separated list.

There is another function CONCAT_WS in Hive that can be used to specify the custom delimiter.