[ 
https://issues.apache.org/jira/browse/HIVE-16149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

slim bouguerra resolved HIVE-16149.
-----------------------------------
    Resolution: Invalid

> Druid query path fails when using LLAP mode
> -------------------------------------------
>
>                 Key: HIVE-16149
>                 URL: https://issues.apache.org/jira/browse/HIVE-16149
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Druid integration
>            Reporter: slim bouguerra
>            Assignee: Ashutosh Chauhan
>
> {code}
> hive> select i_item_desc ,i_category ,i_class ,i_current_price ,i_item_id 
> ,sum(ss_ext_sales_price)
>     > as itemrevenue 
> ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over (partition by 
> i_class) as revenueratio
>     > from tpcds_store_sales_sold_time_1000_day_all
>     > where  (i_category ='Jewelry' or  i_category = 'Sports' or i_category 
> ='Books') and `__time` >= cast('2001-01-12' as date) and `__time` <= 
> cast('2001-02-11' as date)
>     > group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price 
> order by i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio limit 10;
> Query ID = sbouguerra_20170308131436_225330b7-1142-4e4e-a05a-46ef544c8ee8
> Total jobs = 1
> Launching Job 1 out of 1
> Status: Running (Executing on YARN cluster with App id 
> application_1488231257387_1862)
> ----------------------------------------------------------------------------------------------
>         VERTICES      MODE        STATUS  TOTAL  COMPLETED  RUNNING  PENDING  
> FAILED  KILLED
> ----------------------------------------------------------------------------------------------
> Map 1                 llap        INITED      1          0        0        1  
>      0       0
> Reducer 2             llap        INITED      2          0        0        2  
>      0       0
> Reducer 3             llap        INITED      1          0        0        1  
>      0       0
> ----------------------------------------------------------------------------------------------
> VERTICES: 00/03  [>>--------------------------] 0%    ELAPSED TIME: 59.68 s
> ----------------------------------------------------------------------------------------------
> Status: Failed
> Dag received [DAG_TERMINATE, SERVICE_PLUGIN_ERROR] in RUNNING state.
> Error reported by TaskScheduler [[2:LLAP]][SERVICE_UNAVAILABLE] No LLAP 
> Daemons are running
> Vertex killed, vertexName=Reducer 3, vertexId=vertex_1488231257387_1862_3_02, 
> diagnostics=[Vertex received Kill while in RUNNING state., Vertex did not 
> succeed due to DAG_TERMINATED, failedTasks:0 killedTasks:1, Vertex 
> vertex_1488231257387_1862_3_02 [Reducer 3] killed/failed due 
> to:DAG_TERMINATED]
> Vertex killed, vertexName=Reducer 2, vertexId=vertex_1488231257387_1862_3_01, 
> diagnostics=[Vertex received Kill while in RUNNING state., Vertex did not 
> succeed due to DAG_TERMINATED, failedTasks:0 killedTasks:2, Vertex 
> vertex_1488231257387_1862_3_01 [Reducer 2] killed/failed due 
> to:DAG_TERMINATED]
> Vertex killed, vertexName=Map 1, vertexId=vertex_1488231257387_1862_3_00, 
> diagnostics=[Vertex received Kill while in RUNNING state., Vertex did not 
> succeed due to DAG_TERMINATED, failedTasks:0 killedTasks:1, Vertex 
> vertex_1488231257387_1862_3_00 [Map 1] killed/failed due to:DAG_TERMINATED]
> DAG did not succeed due to SERVICE_PLUGIN_ERROR. failedVertices:0 
> killedVertices:3
> FAILED: Execution Error, return code 2 from 
> org.apache.hadoop.hive.ql.exec.tez.TezTask. Dag received [DAG_TERMINATE, 
> SERVICE_PLUGIN_ERROR] in RUNNING state.Error reported by TaskScheduler 
> [[2:LLAP]][SERVICE_UNAVAILABLE] No LLAP Daemons are runningVertex killed, 
> vertexName=Reducer 3, vertexId=vertex_1488231257387_1862_3_02, 
> diagnostics=[Vertex received Kill while in RUNNING state., Vertex did not 
> succeed due to DAG_TERMINATED, failedTasks:0 killedTasks:1, Vertex 
> vertex_1488231257387_1862_3_02 [Reducer 3] killed/failed due 
> to:DAG_TERMINATED]Vertex killed, vertexName=Reducer 2, 
> vertexId=vertex_1488231257387_1862_3_01, diagnostics=[Vertex received Kill 
> while in RUNNING state., Vertex did not succeed due to DAG_TERMINATED, 
> failedTasks:0 killedTasks:2, Vertex vertex_1488231257387_1862_3_01 [Reducer 
> 2] killed/failed due to:DAG_TERMINATED]Vertex killed, vertexName=Map 1, 
> vertexId=vertex_1488231257387_1862_3_00, diagnostics=[Vertex received Kill 
> while in RUNNING state., Vertex did not succeed due to DAG_TERMINATED, 
> failedTasks:0 killedTasks:1, Vertex vertex_1488231257387_1862_3_00 [Map 1] 
> killed/failed due to:DAG_TERMINATED]DAG did not succeed due to 
> SERVICE_PLUGIN_ERROR. failedVertices:0 killedVertices:3
> {code}



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

Reply via email to