Support Questions
Find answers, ask questions, and share your expertise

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

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

8 REPLIES 8

Re: 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

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

Re: 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

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

Re: 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

where can i run this cmd

Re: 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

Explorer

in hive cli

Re: 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

@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

Re: 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

i can'i fide hive-site.xml

Re: 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

@Sindhu

still the same probleme

Re: 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

@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