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 query not running on CDH 5.10

SOLVED Go to solution

Hive query not running on CDH 5.10

Expert Contributor

Hi All,

 

I am trying to run the simple create table SQL query using Pig editor in Hue and query is keep running. I have aborted it after 10 minutes. Please let me know why it's taking long time. Note: when I careated database, it took fraction of second.

 

Please let me know whether I need to do any other initial settings.

 

Query History:



Query History:
20 minutes ago              
CREATE TABLE test.EMP(e_id INT, name STRING, age INT,gender STRING, sal INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE
21 minutes ago              
show DATABASES
21 minutes ago              
Create DATABASE test
21 minutes ago              
show DATABASES
22 minutes ago              
CREATE TABLE EMP(e_id INT, name STRING, age INT,gender STRING, sal INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE

Query:

CREATE TABLE test.EMP(e_id INT, name STRING, age INT,gender STRING, sal INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE;

 

Logs:

INFO  : Compiling command(queryId=hive_20170516191919_aa55bf85-aa68-4297-8e0f-a13c43cecf38): CREATE TABLE test.EMP(e_id INT, name STRING, age INT,gender STRING, sal INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE
INFO  : Semantic Analysis Completed
INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
INFO  : Completed compiling command(queryId=hive_20170516191919_aa55bf85-aa68-4297-8e0f-a13c43cecf38); Time taken: 0.01 seconds
Bad status for request TFetchResultsReq(fetchType=1, operationHandle=TOperationHandle(hasResultSet=False, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret='ew&8\x00PN\xe3\x983\x9d\xf3\xb5\xd98\xca', guid='q\xc3\xd4\xfd\xab\xedN\x92\xa8\x98#4S%\xb2T')), orientation=0, maxRows=-1):
TFetchResultsResp(status=TStatus(errorCode=0, errorMessage='The operation has been closed and its log file /var/log/hive/operation_logs/4643f24d-54fe-466a-9bd6-e0491a39f1c7/71c3d4fd-abed-4e92-a898-23345325b254 has been removed.', sqlState=None, infoMessages=['*org.apache.hive.service.cli.HiveSQLException:The operation has been closed and its log file /var/log/hive/operation_logs/4643f24d-54fe-466a-9bd6-e0491a39f1c7/71c3d4fd-abed-4e92-a898-23345325b254 has been removed.:24:23', 'org.apache.hive.service.cli.operation.OperationManager:getOperationLogRowSet:OperationManager.java:311', 'org.apache.hive.service.cli.session.HiveSessionImpl:fetchResults:HiveSessionImpl.java:770', 'sun.reflect.GeneratedMethodAccessor11:invoke::-1', 'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43', 'java.lang.reflect.Method:invoke:Method.java:606', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78', 'org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36', 'org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63', 'java.security.AccessController:doPrivileged:AccessController.java:-2', 'javax.security.auth.Subject:doAs:Subject.java:415', 'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1796', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59', 'com.sun.proxy.$Proxy29:fetchResults::-1', 'org.apache.hive.service.cli.CLIService:fetchResults:CLIService.java:462', 'org.apache.hive.service.cli.thrift.ThriftCLIService:FetchResults:ThriftCLIService.java:691', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults:getResult:TCLIService.java:1553', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults:getResult:TCLIService.java:1538', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:286', 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1145', 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:615', 'java.lang.Thread:run:Thread.java:745', '*java.io.IOException:Stream closed:30:6', 'java.io.BufferedReader:ensureOpen:BufferedReader.java:115', 'java.io.BufferedReader:readLine:BufferedReader.java:310', 'java.io.BufferedReader:readLine:BufferedReader.java:382', 'org.apache.hadoop.hive.ql.session.OperationLog$LogFile:readResults:OperationLog.java:199', 'org.apache.hadoop.hive.ql.session.OperationLog$LogFile:read:OperationLog.java:152', 'org.apache.hadoop.hive.ql.session.OperationLog:readOperationLog:OperationLog.java:114', 'org.apache.hive.service.cli.operation.OperationManager:getOperationLogRowSet:OperationManager.java:309'], statusCode=3), results=None, hasMoreRows=None)

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Hive query not running on CDH 5.10

Expert Contributor

I am able to resolve this issue. Just started the Zookeeper and Ozzie. It's working now.

1 REPLY 1

Re: Hive query not running on CDH 5.10

Expert Contributor

I am able to resolve this issue. Just started the Zookeeper and Ozzie. It's working now.