slim bouguerra created HIVE-16149: ------------------------------------- Summary: 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)