How to substractduration of 1min from a ISO time in Pig ?

[#1]

@Pradeep Allu

See if this helps https://pig.apache.org/docs/r0.11.1/api/org/apache/pig/builtin/SubtractDuration.html

[#2]

@Pradeep Allu

you need to refer to the standard for ISO 8601 to specify duration or period linked Here. For example PT1M is a one-minute duration. Here's the implementation of the function if you need clear understanding. Get to know jodatime java library and Period object to get a handle on this function. Excellent question!

[#3 · Accepted solution]

all the comments mentioned here are correct,this is small example


emp = load 'data' using PigStorage(',') as (empno,ename ,job,mgr,hiredate ,sal,comm,deptno);
each_date = foreach emp generate ToDate(hiredate,'dd-MMM-yyyy') as mydate;
subt = foreach each_date generate mydate,SubtractDuration(mydate,'PT1M');
dump subt;

[#4]

use ISO time pattern instead of dd-MMM-yyyy from my code