在PIG中找到start_times和end_times之间的差异 [英] Finding the difference between start_times and end_times in PIG

问题描述

任何人都可以告诉我如何在PIG中找到两次之间的区别...

Could anyone please tell me how to find the difference between two times in PIG...

例如，下面是示例Start_Times和End_Times，我需要在PIG中找到Start_Time和End_Time之间的差异.

For e.g., Below are the sample Start_Times and End_Times, I need to find the difference between Start_Time and End_Time in PIG.

12:31:38,14:54:04
10:18:34,13:30:56
13:37:43,15:18:57
08:15:10,11:28:17

预先感谢...

推荐答案

找不到简单的方法.这是一种解决方法:

Couldn't find a straightforward way. Here is a workaround:

    t = LOAD ' input/data' USING PigStorage(',') as (time1:chararray,time2:chararray);
    u = FOREACH t GENERATE SecondsBetween(ToDate(time2,'HH:mm:ss'),ToDate(time1,'HH:mm:ss')) as seconds;
    v = FOREACH u GENERATE seconds/3600 as hours,(seconds%3600)/60 as minutes,(seconds%3600)%60 as seconds;
    STORE v into 'output/data' USING PigStorage(':');

使用以下代码输出示例数据:

Output for your sample data with this code:

    2:22:26
    3:12:22
    1:41:14
    3:13:7

这篇关于在PIG中找到start_times和end_times之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！