Data Frame Operations - Select Clause and Functions - Basic String Manipulation Functions

Let us go through some of the important functions using which we can manipulate strings. We should spend enough time to understand how to manipulate strings using available functions.

* Case conversion functions – lower, upper, initcap
* Trim functions – trim, rtrim, ltrim
* Padding functions – lpad, rpad
* Typecasting – we can use Hive function cast as part of
selectExpr to change the data type of data to its original type (eg:
date might be a string, but we can extract year part and convert
into an integer)
* getting length

Connect with me or follow me at