Question

Describe TRIM function in Hive with example?

Answer 1

TRIM function will remove the spaces associated with a string.

Example: TRIM(‘ Hadoop ‘);

Output: Hadoop.

If we want to remove only leading or trailing spaces then we can specify the below commands respectively.

LTRIM(‘ Hadoop’);

RTRIM(‘Hadoop ‘);