in Big Data | Hadoop by
Q:
How TRIM and RPAD functions work in Hive?

1 Answer

0 votes
by
TRIM and RPAD functions are for processing String data type in Hive.

With TRIM function we can delete the spaces before and after  a String. It is very useful for formatting user input in which user may have  entered extra  spaces. The other variations of TRIM function are LTRIM and RTRIM that remove spaces from left and

 

right side of the string respectively.

E.g. TRIM(‘ Smith ’) Smith

RPAD function is used to add padding (extra spaces) in a String on the right hand side. So that String reaches a specified length. LPAD function is same as RPAD but it pads on the left hand side of String.

E.g. Let say we have  a String “Hello”.

LPAD(‘Hello’,8,’ ')

Hello

 

We can also specify our optional padding character in RPAD and LPAD functions.

These functions are similar to the ones in SQL.
Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
0 votes
asked Jan 11, 2020 in Big Data | Hadoop by rajeshsharma
...