[
https://issues.apache.org/jira/browse/HIVE-14362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15432091#comment-15432091
]
Pengcheng Xiong commented on HIVE-14362:
----------------------------------------
Hi [~gopalv], it works for q tests.... see explain analyze 1-5. And i really
tested it on the cluster and it worked for some simple queries. Thanks for
finding this out and I agree with you. I think we really need to change that to
HDFS temp folder somewhere. We can improve that anyway. Btw, I assume that your
major concern is performance difference, rather than functional, right? Thanks.
:)
> Support explain analyze in Hive
> -------------------------------
>
> Key: HIVE-14362
> URL: https://issues.apache.org/jira/browse/HIVE-14362
> Project: Hive
> Issue Type: New Feature
> Reporter: Pengcheng Xiong
> Assignee: Pengcheng Xiong
> Attachments: HIVE-14362.01.patch, HIVE-14362.02.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)