CREATE TABLE geolocation STORED AS ORC AS SELECT * FROM geolocation_stage; the message in log : INFO : Tez session hasn't been created yet. Opening session and stay like that. plz any help

[#1]

INFO : Tez session hasn't been created yet. Opening session ERROR : Failed to execute tez graph. org.apache.tez.dag.api.TezException: org.apache.hadoop.yarn.exceptions.YarnException: Failed to submit application_1466762507013_0004 to YARN : Application application_1466762507013_0004 submitted by user jchokri to unknown queue: default at org.apache.tez.client.TezClient.start(TezClient.java:413) at org.apache.hadoop.hive.ql.exec.tez.TezSessionState.open(TezSessionState.java:196) at org.apache.hadoop.hive.ql.exec.tez.TezTask.updateSession(TezTask.java:271) at org.apache.hadoop.hive.ql.exec.tez.TezTask.execute(TezTask.java:151) at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:160) at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:89) at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1720) at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1477) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1254) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1118) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1113) at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:154) at org.apache.hive.service.cli.operation.SQLOperation.access$100(SQLOperation.java:71) at org.apache.hive.service.cli.operation.SQLOperation$1$1.run(SQLOperation.java:206) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:218) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.apache.hadoop.yarn.exceptions.YarnException: Failed to submit application_1466762507013_0004 to YARN : Application application_1466762507013_0004 submitted by user jchokri to unknown queue: default at org.apache.hadoop.yarn.client.api.impl.YarnClientImpl.submitApplication(YarnClientImpl.java:271) at org.apache.tez.client.TezYarnClient.submitApplication(TezYarnClient.java:72) at org.apache.tez.client.TezClient.start(TezClient.java:408) ... 22 more

[#2]

Looks like your cluster doesn't have default queue in schedule, please follow below similar post.

https://community.hortonworks.com/questions/26646/failed-to-execute-tez-graph.html

[#3]

do you have default query setup with yarn scheduler? try to submit to other available queue using set mapred.job.queue.name=<queue_name> and see if issue persist

[#4]

where can i run this cmd

[#5]

in hive cli

[#6]

@jihed chokri

Set the queue name in the hive cli and beeline as below:

set set mapred.job.queue.name=<queue_name>;

Or under hive-site.xml as property:

<property>
  <name>mapred.job.queue.name</name>
  <value>queue_name</value>
</property>

Thanks and Regards,

Sindhu

[#7]

i can'i fide hive-site.xml

[#8]

@Sindhu

still the same probleme

[#9]

@jihed chokri

Please try following:

• Login to Hive Cli.
• Run command set mapred.job.queue.name=<queue_name>;
• Run command set hive.execution.engine=mr;
• Run the query.

Thanks and Regards,

Sindhu