pig tutorial - apache pig tutorial - Apache Pig - DaysBetween() - pig latin - apache pig - pig hadoop

What is DaysBetween() Function?

  • The DaysBetween function subtracts the FromDate from the ToDate, returning the number whole day difference.
  • The time value of each date is taken account of - only whole 24 hour chunks are counted as whole days.
 days between in apache pig

Learn apache pig - apache pig tutorial - days between in apache pig - apache pig examples - apache pig programs

DaysBetween() function in Apache Pig

  • This function accepts two date-time objects and calculates the number of days between the two given date-time objects.


grunt> DaysBetween(datetime1, datetime2)


  • Ensure that we have a file named wikitechy_doj_dob.txt in the HDFS directory /pig_data/.
  • This file contains the date-of-birth and date-of-joining details of a particular person, id, dateof-birth, and date-of-join as given below.


001,26/09/1989 09:00:00,16/01/2015 09:00:00
002,20/06/1980 10:22:00,10/08/2011 09:00:00
003,19/12/1990 03:11:44,25/10/2012 09:00:00 
  • We have loaded this file into Pig with a relation named doj_dob_data as given below.
doj_dob_data = LOAD 'hdfs://localhost:9000/pig_data/wikitechy_doj_dob.txt' USING PigStorage(',')
   as (id:int, dob:chararray, doj:chararray);
  • Now you can calculate the number of days between date-of-birth and date-of-join of the employees using the DaysBetween() function.
grunt> daysbetween_data = foreach doj_dob_data generate DaysBetween(ToDate(doj,'dd/MM/yyyy HH:mm:ss'),
   ToDate(dob,'dd/MM/yyyy HH:mm:ss'));


Verify the contents of the relation using the Dump operator as given below.

grunt> Dump daysbetween_data;


  • The above statement stores the result in the relation named daysbetween_data.

Related Searches to Apache Pig - DaysBetween()

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.