In this blog, we will learn how to sort rows in spark dataframe based on some column values.
White spaces can be a headache if not removed before processing data. We will learn how to remove spaces from data in spark using inbuilt functions.
In this blog, we will learn how to use rpad and lpad functions to add padding to data in spark dataframe.
This blog is intended to be a quick reference for the most commonly used string functions in Spark. It will cover all of the core string processing operations that are supported by Spark. In addition, it should serve as a useful guide for users who wish to easily integrate these into their own applications.
In this blog, we are going to learn how to format dates in spark along with, changing date format and converting strings to dates with proper format.
we need to find a difference between dates or find a date after or before “n” days from a given date.
We are going to use spark function to solve such problems.
Working with timestamps while processing data can be a headache sometimes. Luckily Spark has some in-built functions to make our life easier when working with timestamps. Let us go over these functions.
Spark provides multiple Date and Timestamp functions to make processing dates easier. In this blog, we will see the date and timestamp functions with examples.
In this blog, we will learn how to use select and expr in the Spark data frame. We will learn multiple use cases along with selectExpr.
We will go through common column operations like add, rename, list, select, and dropping a column from spark dataframe.
We will learn how to add multiple partitions to hive table using msck repair table command in hive.
In this blog, we will learn how to insert data in partitions in hive table. We will write queries to insert data in static as well as dynamic partitions.