Rajesh Balamohan created HIVE-16066:
---------------------------------------

             Summary: NPE in ExplainTask
                 Key: HIVE-16066
                 URL: https://issues.apache.org/jira/browse/HIVE-16066
             Project: Hive
          Issue Type: Bug
            Reporter: Rajesh Balamohan
            Priority: Minor


{noformat}
2017-02-28T20:05:13,412  WARN [ATS Logger 0] hooks.ATSHook: Failed to submit 
plan to ATS for user_20170228200511_b05d6eaf-7599-4539-919c-5d3df8658c99
java.lang.NullPointerException
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:803) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:817) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:817) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:817) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:817) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:817) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:817) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:817) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:817) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:817) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputList(ExplainTask.java:658) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:984) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputMap(ExplainTask.java:592) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:970) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:691) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputPlan(ExplainTask.java:1059) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.outputStagePlans(ExplainTask.java:1203)
 ~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.getJSONPlan(ExplainTask.java:306) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.getJSONPlan(ExplainTask.java:251) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
        at org.apache.hadoop.hive.ql.hooks.ATSHook$2.run(ATSHook.java:192) 
~[hive-exec-2.2.0-SNAPSHOT.jar:2.2.0-SNAPSHOT]
{noformat}


Query:
{noformat}

select  i_item_id,
        avg(cs_quantity) agg1,
        avg(cs_list_price) agg2,
        avg(cs_coupon_amt) agg3,
        avg(cs_sales_price) agg4
 from catalog_sales, customer_demographics, date_dim, item, promotion
 where catalog_sales.cs_sold_date_sk = date_dim.d_date_sk and
       catalog_sales.cs_item_sk = item.i_item_sk and
       catalog_sales.cs_bill_cdemo_sk = customer_demographics.cd_demo_sk and
       catalog_sales.cs_promo_sk = promotion.p_promo_sk and
       cd_gender = 'F' and
       cd_marital_status = 'W' and
       cd_education_status = 'Primary' and
       (p_channel_email = 'N' or p_channel_event = 'N') and
       d_year = 1998
 group by i_item_id
 order by i_item_id
 limit 100
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to