in reply to Analytics on Hash Arrays

Please show the code you've tried - How do I post a question effectively? Normally, PerlMonks is not a code writing service, and the more effort you put into asking a question, the more help you get.

You said before "I am working DBA for more than 12 Years, I can meet this requirement in no time if this was in SQL." At the very least, could you describe how you would solve this requirement in SQL?

Replies are listed 'Best First'.
Re^2: Analytics on Hash Arrays
by yasser8@gmail.com (Novice) on Jun 24, 2015 at 14:17 UTC

    In SQL, using Analytical function would meet requirement. Something as shown below 

    value-lag(value) over (order by CollectionTime,metric)

    [download]

    My problem is with assigning the value for Hash key defined as Time in this case, and then Subtract it from latest value to the oldest value.

    No idea how to do it in perl, some hint or suggestions would be very helpful to me.

[reply]
[d/l]

In Section Seekers of Perl Wisdom