The ELT function in Apache Hive helps in retrieving the Nth element from the list of the strings provided. This is equivalent to ELT in
Date Truncation in Apache Hive
This function returns the truncated date to the unit defined by the format. This will aim to return the first day of the specified month
Converting string into date – Apache Hive
TO_DATE function in Apache Hive helps in converting the string into DATE format. If the string has date and time, it will convert and return
Formatting the date in Apache Hive
The “Date Format” function is used but not limited to the following situations. If the current or default date format needs to be changed to
Get last day of the month in Apache Hive
LAST_DAY function returns the last day of the month which the date belongs to. Date is a string in the format ‘yyyy-MM-dd HH:mm:ss’ or ‘yyyy-MM-dd’.
Printf Function in Apache Hive
The PRINTF function returns the formatted input according to the printf-style format string. When using hive scripts, this would be beneficial. Syntax: printf(String format, Obj…
Big Data & SQL 