[
https://issues.apache.org/jira/browse/AMBARI-14559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15085402#comment-15085402
]
Hadoop QA commented on AMBARI-14559:
------------------------------------
{color:red}-1 overall{color}. Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/12780696/AMBARI-14559_branch-2.2.patch
against trunk revision .
{color:green}+1 @author{color}. The patch does not contain any @author
tags.
{color:red}-1 tests included{color}. The patch doesn't appear to include
any new or modified tests.
Please justify why no new tests are needed for this
patch.
Also please list what manual steps were performed to
verify this patch.
{color:green}+1 javac{color}. The applied patch does not increase the
total number of javac compiler warnings.
{color:green}+1 release audit{color}. The applied patch does not increase
the total number of release audit warnings.
{color:green}+1 core tests{color}. The patch passed unit tests in
contrib/views/hive.
Test results:
https://builds.apache.org/job/Ambari-trunk-test-patch/4789//testReport/
Console output:
https://builds.apache.org/job/Ambari-trunk-test-patch/4789//console
This message is automatically generated.
> Hive View Visual explain caches and doesn't account for settings changes
> ------------------------------------------------------------------------
>
> Key: AMBARI-14559
> URL: https://issues.apache.org/jira/browse/AMBARI-14559
> Project: Ambari
> Issue Type: Bug
> Components: ambari-views
> Reporter: Pallav Kulshreshtha
> Assignee: Pallav Kulshreshtha
> Fix For: 2.4.0
>
> Attachments: AMBARI-14559_branch-2.2.patch, Map Join.png, Shuffle
> Join.png
>
>
> A setting like hive.auto.convert.join will often radically change a Hive
> explain plan. In particular the query below will be a map join or shuffle
> join depending on this setting being true or false, respectively.
> What I see in the Hive View is that when I open visual explain, I get the
> correct explain plan based on the setting at that time. If I go and change
> the setting, then go back to the visual explain, the explain is not updated.
> If I reload the tab, the correct explain plan will show up when I go back to
> the explain view.
> See attached shots.
> Query I use is this:
> {code}
> select time_by_day.the_year as c0, time_by_day.quarter as c1,
> count(sales_fact_1997.product_id) as m0,
> sum(sales_fact_1997.unit_sales) as m1,
> sum(sales_fact_1997.store_sales) as m2,
> sum(sales_fact_1997.store_cost) as m3,
> count(distinct sales_fact_1997.customer_id) as m4
> from time_by_day as time_by_day,
> sales_fact_1997 as sales_fact_1997 where
> sales_fact_1997.time_id = time_by_day.time_id and
> time_by_day.the_year = 1997 group by time_by_day.the_year,
> time_by_day.quarter ;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)