ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Siddharth Wagle (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AMBARI-11317) Avoid Client side merge sort on aggregator queries
Date Thu, 21 May 2015 20:31:17 GMT
Siddharth Wagle created AMBARI-11317:
----------------------------------------

             Summary: Avoid Client side merge sort on aggregator queries
                 Key: AMBARI-11317
                 URL: https://issues.apache.org/jira/browse/AMBARI-11317
             Project: Ambari
          Issue Type: Task
          Components: ambari-metrics
    Affects Versions: 2.0.0
            Reporter: Siddharth Wagle
            Assignee: Siddharth Wagle
             Fix For: 2.1.0


- Existing query plan:
{code}
0: jdbc:phoenix:localhost:61181:/hbase> explain select * from METRIC_RECORD WHERE SERVER_TIME
> 1432139517000 AND SERVER_TIME < 1432149517000 ORDER BY METRIC_NAME, HOSTNAME, APP_ID,
SERVER_TIME limit 5760;
+------------+
|    PLAN    |
+------------+
| CLIENT PARALLEL 2-WAY FULL SCAN OVER METRIC_RECORD |
|     SERVER FILTER BY (SERVER_TIME > 1432139517000 AND SERVER_TIME < 1432149517000)
|
|     SERVER TOP 5760 ROWS SORTED BY [METRIC_NAME, HOSTNAME, APP_ID, SERVER_TIME] |
| CLIENT MERGE SORT |
+------------+
4 rows selected (0.061 seconds)
{code}

- Modified query plan.
{code}
0: jdbc:phoenix:localhost:61181:/hbase> explain select * from METRIC_RECORD WHERE SERVER_TIME
> 1432139517000 AND SERVER_TIME < 1432149517000 ORDER BY METRIC_NAME, HOSTNAME, SERVER_TIME,
APP_ID, INSTANCE_ID limit 5760;
+------------+
|    PLAN    |
+------------+
| CLIENT PARALLEL 1-WAY FULL SCAN OVER METRIC_RECORD |
|     SERVER FILTER BY (SERVER_TIME > 1432139517000 AND SERVER_TIME < 1432149517000)
|
|     SERVER 5760 ROW LIMIT |
| CLIENT 5760 ROW LIMIT |
+------------+
4 rows selected (0.034 seconds)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message