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.

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

Highlighted

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
Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Don't have an account?
Coming from Hortonworks? Activate your account here