Hive: trim: trim all trailing and leading spaces

Signature

trim(string str)

Trim all trailing and leading spaces.

hive> SELECT concat(trim('    Hello    '), 'World');
OK
_c0
HelloWorld

Previous                                                    Next                                                    Home