Padding Functions in Apache Hive & Apache Impala

The padding functions are used to fill the left or right side of a string with a specific set of characters. These functions are useful for formatting the output of a query. It is necessary to specify the padding length, which is a number representing the total length of the string returned after padding.

  • Note: The below specified functions are common in both Apache Hive & Apache Impala.

Apache Hive provides LPAD and RPAD features that are similar in functionality to those that available in relational database systems.

SELECT LPAD(‘bigdatansql’,19, ‘https: //’);
This returns https://bigdatansql as output.

SELECT LPAD(289,10,0);
This returns 0000000289 as output to make it 10 characters in length as provided.

SELECT RPAD(‘bigdatansql’,15,’.com’);
This returns as output to make it 15 characters in length as provided.

Refer to the below screenshot.


Hope you find this article helpful.

Please click on the follow button to receive updates on latest posts.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s