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)
