gistfile1.txt

presto:store> select * from metrics_rollup60 where name = 'bytes_sent.miss.2747t.hd' limit 10;
           name           |          time           | count  |    sum
--------------------------+-------------------------+--------+------------
 bytes_sent.miss.2747t.hd | 2014-10-29 18:45:00.000 |   9893 |  112072036
 bytes_sent.miss.2747t.hd | 2014-10-29 18:46:00.000 | 166883 | 1637354586
 bytes_sent.miss.2747t.hd | 2014-10-29 18:47:00.000 | 223586 | 2271573231
 bytes_sent.miss.2747t.hd | 2014-10-29 18:48:00.000 | 232457 | 2432849911
 bytes_sent.miss.2747t.hd | 2014-10-29 18:49:00.000 | 234066 | 2453397952
 bytes_sent.miss.2747t.hd | 2014-10-29 18:50:00.000 | 240202 | 2371110880
 bytes_sent.miss.2747t.hd | 2014-10-29 18:51:00.000 | 231517 | 2360339360
 bytes_sent.miss.2747t.hd | 2014-10-29 18:52:00.000 | 220672 | 2353953186
 bytes_sent.miss.2747t.hd | 2014-10-29 18:53:00.000 | 229232 | 2397765383
 bytes_sent.miss.2747t.hd | 2014-10-29 18:54:00.000 | 230842 | 2410652695
(10 rows)


presto:store> select * from metrics_rollup60 where name = 'bytes_sent.2747t.hd' limit 10;
        name         |          time           | count  |    sum
---------------------+-------------------------+--------+------------
 bytes_sent.2747t.hd | 2014-10-29 18:45:00.000 |   9893 |  112072036
 bytes_sent.2747t.hd | 2014-10-29 18:46:00.000 | 166883 | 1637354586
 bytes_sent.2747t.hd | 2014-10-29 18:47:00.000 | 223586 | 2271573231
 bytes_sent.2747t.hd | 2014-10-29 18:48:00.000 | 232457 | 2432849911
 bytes_sent.2747t.hd | 2014-10-29 18:49:00.000 | 234066 | 2453397952
 bytes_sent.2747t.hd | 2014-10-29 18:50:00.000 | 240202 | 2371110880
 bytes_sent.2747t.hd | 2014-10-29 18:51:00.000 | 231517 | 2360339360
 bytes_sent.2747t.hd | 2014-10-29 18:52:00.000 | 220672 | 2353953186
 bytes_sent.2747t.hd | 2014-10-29 18:53:00.000 | 229232 | 2397765383
 bytes_sent.2747t.hd | 2014-10-29 18:54:00.000 | 230842 | 2410652695
(10 rows)