Search

Describe TRIM function in Hive with example?



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 ‘);