pig tutorial - apache pig tutorial - Apache Pig - MonthsBetween(datetime1, datetime2) Function - pig latin - apache pig - pig hadoop

What is MonthsBetween(datetime1,datetime2) function in Apache Pig ?

  • The MonthsBetween(datetime1,datetime2) function will accept the two date-time objects and also calculates the number of months which is done between the two given date-time objects.
  • The MonthsBetween(datetime1,datetime2) function will returns the number of months which is done between date-time datetime1 and datetime2.
  • The MonthsBetween(datetime1,datetime2) calculates the fractional portion of the result and also considers the difference of the time components which is given between datetime1 and datetime2.


grunt>MonthsBetween(datetime1, datetime2) 


  • Ensure that there is a file named wikitechy_doj_dob.txt in the HDFS directory /pig_data/.
  • The file contains the date-of-birth details and date-of-joining details of a particular person, id, dateof-birth and date-of-joining.


131,27/10/1990 09:00:00,17/02/2016 09:00:00
132,21/07/1981 10:22:00,11/09/2012 09:00:00 
133,20/01/1992 03:11:44,26/11/2013 09:00:00 
  • We have loaded the file into Pig with a relation name doj_dob_data which is given below:
doj_dob_data = LOAD 'hdfs://localhost:9000/pig_data/wikitechy_doj_dob.txt' USING PigStorage(',')
as (id:int, dob:chararray, doj:chararray);
  • We can calculate the number of minutes which is done between date-of-birth and date-of-joining of the employees by using the MonthsBetween() function which is given below:
grunt>monthsbetween_data = foreachdoj_dob_data generate
MinutesBetween(ToDate(doj,'dd/MM/yyyy HH:mm:ss'),ToDate(dob,'dd/MM/yyyy HH:mm:ss'));


  • We need to verify the contents of the relation by using the Dump operator which is given below:
grunt> Dump monthsbetween;


  • The above statement stores the result in the relation named monthsbetween_data

Related Searches to Apache Pig GetMilliSecond(datetime) Function

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.