Apache Hive provides many features that SQL developers are familiar with. The behavior in much of the functions is the same. Such functions help to interpret, translate, quantify and format data.
The aim of this post is to let you know the functions that help view data in various character cases, such as Uppercase, Lowercase and Title case.
- Note: The below specified functions are common in both Apache Hive & Apache Impala.
The Apache Hive UPPER function converts all string letters to upper case, and the LOWER function converts all string letters to lower case. You will use the InitCap function to convert the letters into the Proper Case/Title case.
Refer to the below examples:
SELECT UPPER(‘This is posted on BIGDATAnSQL blog’);
This converts the input string characters into capital letters.
SELECT LOWER(‘This is posted on BIGDATAnSQL blog’);
This converts the input string characters into lowercase letters.
SELECT InitCap(‘This is posted on BIGDATAnSQL blog’);
This converts the input string characters into title case / proper case letters.
Hope you liked this post.
Please click on the follow button to receive updates on latest posts.
Big Data and SQL 
4 comments