Hive String functions examples Archives -

Concat and concat_ws function in Hive with examples

Concat function in Hive The concat() function add two or more strings or bytes together. If any of the value

COALESCE function in Hive Coalesce is a conditional function in Hive which is used to handle the NULL values. It

Trim function in Hive Trim function removes the extra space from both ends of the string value. In other words,

Hive instr function Instr is a string function which returns the position of the first occurrence of substring in the

Regexp_extract function in hive In the programming languages, Regular expression is used to search the certain pattern on the string

Hive substring : Substring is a built-in string function in Hive which is used to extract a part of a

Hive provides few functions to handle the string replacement. Using string replace functions , we can replace some characters or