Friday 23 December 2022

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

No comments:

Post a Comment