我在找每天最冷的时间。我的数据如下:
(2015/12/27,12AM,32.0)
(2015/12/27,12PM,34.0)
(2015/12/28,10AM,26.1)
(2015/12/28,10PM,28.0)
(2015/12/28,11AM,27.0)
(2015/12/28,11PM,28.9)
(2015/12/28,12AM,25.0)
(2015/12/28,12PM,26.100000000000005)
(2015/12/29,10AM,22.45)
(2015/12/29,10PM,26.1)
(2015/12/29,11AM,24.1)
(2015/12/29,11PM,25.0)
(2015/12/29,12AM,28.9)我每一天都分组,用下面的代码找到Min Temp:
minTemps = FOREACH gdate2 GENERATE group as day,MIN(removeDash.temp) as minTemp;它提供了这样的输出:
(2015/12/18,17.1)
(2015/12/19,12.9)
(2015/12/20,23.0)
(2015/12/21,32.0)
(2015/12/22,30.899999999999995)
(2015/12/23,36.05)
(2015/12/24,30.45)
(2015/12/25,26.55)
(2015/12/26,28.899999999999995)
(2015/12/27,26.1)
(2015/12/28,23.55)
(2015/12/29,21.0)我的问题是:我还需要最低温度发生的时间。我怎样才能得到这个时间呢?
发布于 2018-05-08 15:56:29
如果我正确理解你的问题,按(day, hour)分组是行不通的,因为这会发现每小时最冷的温度,而不是每一天最冷的时候和最冷的温度。
相反,使用嵌套的foreach:
B = GROUP A BY day;
C = FOREACH B {
orderd = ORDER A BY temp ASC;
limitd = LIMIT orderd 1;
GENERATE FLATTEN(limitd) AS (day, hour, temp);
};按日分组,然后按温度排序同一天内的所有小时,并只选择最高记录。请注意,如果两个或两个以上小时之间存在平分,则只会选择其中一个小时。
发布于 2018-05-08 03:53:50
是的,您是在正确的track.Modify您的组语句到组的一天和hour.Finally使用扁平在您的组解耦键。
gdate2 = GROUP removeDash by (day,hour);
minTemps = FOREACH gdate2 GENERATE FLATTEN(group) as (day,hour),MIN(removeDash.temp) as minTemp;https://stackoverflow.com/questions/50222993
复制相似问题