Friday, 23 December 2022

Hive: rtrim: Remove right side trailing spaces

Signature

rtrim(string str)

 

Remove all the right side trailing spaces in a string.

hive> SELECT concat(rtrim('  Hello    '), 'world');
OK
_c0
  Helloworld
Time taken: 0.049 seconds, Fetched: 1 row(s)

 

 

Previous                                                    Next                                                    Home

No comments:

Post a Comment