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] [Updated] (AMBARI-11317) Avoid Client side merge sort on aggregator queries
Date Thu, 21 May 2015 20:33:17 GMT

     [ https://issues.apache.org/jira/browse/AMBARI-11317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Siddharth Wagle updated AMBARI-11317:
-------------------------------------
    Attachment: AMBARI-11317.patch

> 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
>
>         Attachments: AMBARI-11317.patch
>
>
> - 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)
> {code}



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

Mime
View raw message