[
https://issues.apache.org/jira/browse/AMBARI-11317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14555233#comment-14555233
]
Hudson commented on AMBARI-11317:
---------------------------------
FAILURE: Integrated in Ambari-trunk-Commit #2673 (See
[https://builds.apache.org/job/Ambari-trunk-Commit/2673/])
AMBARI-11317. Avoid Client side merge sort on aggregator queries. (swagle)
(swagle:
http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=9e5647d99cbaec20878017cc53e1373e88965c20)
*
ambari-metrics/ambari-metrics-timelineservice/src/main/java/org/apache/hadoop/yarn/server/applicationhistoryservice/metrics/timeline/aggregators/TimelineMetricClusterAggregatorMinute.java
*
ambari-metrics/ambari-metrics-timelineservice/src/main/java/org/apache/hadoop/yarn/server/applicationhistoryservice/metrics/timeline/aggregators/TimelineMetricHostAggregator.java
> 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)
