Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive Queries are not working using Tez. Yarn Applications are also stucked in "Accepted" State. How to resolve this issue?

Highlighted

Hive Queries are not working using Tez. Yarn Applications are also stucked in "Accepted" State. How to resolve this issue?

New Contributor

87542-resource-manager-ui.png

I recently installed an Ambari 2.7 cluster on 3 nodes. I am trying to use hive from CLI to run some queries. INSERT query is stuck after some process. Following is the terminal log of hive query execution. Nothing happens after this step.




p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 14.0px Monaco; color: #ffffff; background-color: #000000}
span.s1 {font-variant-ligatures: no-common-ligatures}



INFO  : Compiling command(queryId=hive_20180904161042_8169b625-4408-4974-8ed3-eb837804805f): SELECT TRANSFORM ('---------','--------') USING '--------' AS ------

INFO  : Semantic Analysis Completed (retrial = false)

INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:asn, type:string, comment:null)], properties:null)

INFO  : Completed compiling command(queryId=hive_20180904161042_8169b625-4408-4974-8ed3-eb837804805f); Time taken: 0.068 seconds

INFO  : Executing command(queryId=hive_20180904161042_8169b625-4408-4974-8ed3-eb837804805f): SELECT TRANSFORM ('------','-------') USING '-------' AS -------

INFO  : Query ID = hive_20180904161042_8169b625-4408-4974-8ed3-eb837804805f

INFO  : Total jobs = 1

INFO  : Launching Job 1 out of 1

INFO  : Starting task [Stage-1:MAPRED] in serial mode

INFO  : Subscribed to counters: [] for queryId: hive_20180904161042_8169b625-4408-4974-8ed3-eb837804805f

INFO  : Session is already open