Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 0: jdbc:phoenix:localhost:61181:/ams-hbase-un> select * from METRIC_RECORD_MINUTE WHERE APP_ID='nimbus' AND METRIC_NAME='Used Slots' AND SERVER_TIME > 1468503554000 AND SERVER_TIME < 1468507154000;
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+---------------+
- | METRIC_NAME | HOSTNAME | APP_ID | INSTANCE_ID | SERVER_TIME | UNITS | METRIC_SUM | |
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+---------------+
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468505400000 | | 0.0 | 4 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468505700000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468506000000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468506300000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468506600000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468506900000 | | 0.0 | 4 |
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+---------------+
- 6 rows selected (0.146 seconds)
- 0: jdbc:phoenix:localhost:61181:/ams-hbase-un> select * from METRIC_RECORD_MINUTE WHERE APP_ID='nimbus' AND METRIC_NAME='Used Slots' AND SERVER_TIME > 1468569641000 AND SERVER_TIME < 1468573241000;
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+---------------+
- | METRIC_NAME | HOSTNAME | APP_ID | INSTANCE_ID | SERVER_TIME | UNITS | METRIC_SUM | |
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+---------------+
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468569900000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468570200000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468570500000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468570800000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468571100000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468571400000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468571700000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468572000000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468572300000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468572600000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468572900000 | | 0.0 | 5 |
- | Used Slots | storm-metric-test2-2.openstacklocal | nimbus | | 1468573200000 | | 0.0 | 5 |
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+---------------+
- 12 rows selected (0.122 seconds)
- 0: jdbc:phoenix:localhost:61181:/ams-hbase-un> select * from METRIC_AGGREGATE_MINUTE WHERE APP_ID='nimbus' AND METRIC_NAME='Used Slots' AND SERVER_TIME > 1468503554000 AND SERVER_TIME < 1468507154000;
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+------------------------------------------+---------------+
- | METRIC_NAME | APP_ID | INSTANCE_ID | SERVER_TIME | UNITS | METRIC_SUM | METRIC_COUNT | |
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+------------------------------------------+---------------+
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+------------------------------------------+---------------+
- No rows selected (0.155 seconds)
- 0: jdbc:phoenix:localhost:61181:/ams-hbase-un> select * from METRIC_AGGREGATE_MINUTE WHERE APP_ID='nimbus' AND METRIC_NAME='Used Slots' AND SERVER_TIME > 1468569641000 AND SERVER_TIME < 1468573241000;
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+------------------------------------------+---------------+
- | METRIC_NAME | APP_ID | INSTANCE_ID | SERVER_TIME | UNITS | METRIC_SUM | METRIC_COUNT | |
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+------------------------------------------+---------------+
- | Used Slots | nimbus | | 1468569900000 | | 0.0 | 1 | 0.0 |
- | Used Slots | nimbus | | 1468570200000 | | 0.0 | 1 | 0.0 |
- | Used Slots | nimbus | | 1468570500000 | | 0.0 | 1 | 0.0 |
- | Used Slots | nimbus | | 1468570800000 | | 0.0 | 1 | 0.0 |
- | Used Slots | nimbus | | 1468571100000 | | 0.0 | 1 | 0.0 |
- | Used Slots | nimbus | | 1468571400000 | | 0.0 | 1 | 0.0 |
- | Used Slots | nimbus | | 1468571700000 | | 0.0 | 1 | 0.0 |
- | Used Slots | nimbus | | 1468572000000 | | 0.0 | 1 | 0.0 |
- | Used Slots | nimbus | | 1468572300000 | | 0.0 | 1 | 0.0 |
- | Used Slots | nimbus | | 1468572600000 | | 0.0 | 1 | 0.0 |
- | Used Slots | nimbus | | 1468572900000 | | 0.0 | 1 | 0.0 |
- | Used Slots | nimbus | | 1468573200000 | | 0.0 | 1 | 0.0 |
- +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+----------------------+------------------------------------------+------------------------------------------+---------------+
- 12 rows selected (0.113 seconds)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement