3 59 59.807316959 3 59 59.813843966 3 59 59.823140979 4 0 0.123 4 0 0.345 The first column is the hour, the second column is the minute, the last column is the second with the subseconds following the period. The dataset has over 100 million observations. ... View more

I ran the code, and AVGTPS and PEAKTPS don't look right - They show the same values that I got when I ran my own version:   Hour               Trancount          Average TPS         Peak TPS 3                            188                    3                          3 4                    2191715                    4                          4 5                    2433846                    5                          5 .... 21                  3741828                  21                        21   Doing the math would show that for hour 21, the average TPS would be 1039 (3,741,828 / 3600 (60 sec * 60 minutes)). ... View more

Sample data: 3 59 59.807316959 3 59 59.813843966 3 59 59.823140979 ... 23 59 59.904180944   My sample dataset 9865385 records - a full dataset will contain over 100 million records. ... View more

In addition to arrival rate by hour, the report must include average transactions per second and peak transaction per second. ... View more

HH is hours - the input dataset contains 1 entry per transaction processed - MM is minutes, SS is seconds. This input dataset contains over 100 million records. What I want to calculate is transaction arrival rate by hour. ... View more