Hive TRIM Function: Remove Whitespace

One way to remove white spaces in Hive is by using the TRIM() function. This function can be used to remove leading and trailing spaces from a string, as well as spaces within the string. An example is shown below:

SELECT TRIM('   hello   ') AS trimmed_string;

This will return the result of ‘hello’ after removing leading and trailing spaces.