question Re: How to substractduration of 1min from a ISO time in Pig ? in Archives of Support Questions (Read Only)

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

psivala — Tue, 26 Jan 2016 06:33:09 GMT

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

nsabharwal — Tue, 26 Jan 2016 06:41:15 GMT

@Pradeep Allu

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

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

aervits — Tue, 26 Jan 2016 07:58:10 GMT

@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!

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

bsuresh — Wed, 27 Jan 2016 17:13:58 GMT

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;

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

bsuresh — Wed, 27 Jan 2016 17:16:04 GMT

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