[ 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)