Reply
Highlighted
New Contributor
Posts: 11
Registered: ‎05-15-2017
Accepted Solution

Hive query not running on CDH 5.10

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)

 

New Contributor
Posts: 11
Registered: ‎05-15-2017

Re: Hive query not running on CDH 5.10

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

Announcements