hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pengcheng Xiong (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14362) Support explain analyze in Hive
Date Tue, 30 Aug 2016 20:46:20 GMT

    [ https://issues.apache.org/jira/browse/HIVE-14362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15450103#comment-15450103
] 

Pengcheng Xiong commented on HIVE-14362:
----------------------------------------

pushed to master. Thanks [~ashutoshc], [~gopalv] and [~gszadovszky] for the reviews! [~gopalv],
i will open another jira to support abort stats.

> Support explain analyze in Hive
> -------------------------------
>
>                 Key: HIVE-14362
>                 URL: https://issues.apache.org/jira/browse/HIVE-14362
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 2.1.0
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>             Fix For: 2.2.0
>
>         Attachments: HIVE-14362.01.patch, HIVE-14362.02.patch, HIVE-14362.03.patch, HIVE-14362.05.patch,
HIVE-14362.06.patch, compare_on_cluster.pdf
>
>
> Right now all the explain levels only support stats before query runs. We would like
to have an explain analyze similar to Postgres for real stats after query runs. This will
help to identify the major gap between estimated/real stats and make not only query optimization
better but also query performance debugging easier.



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

Mime
View raw message