The function MONTHS_BETWEEN returns the number of months between the dates specified. If the first expression is later than the second, the outcome is positive,
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Returning Nth element from the list – Apache Hive
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’.
Big Data & SQL 