Hive query not running on CDH 5.10

SatishS — Fri, 16 Sep 2022 11:37:28 GMT

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)

Re: Hive query not running on CDH 5.10

SatishS — Wed, 17 May 2017 03:00:46 GMT

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

question Hive query not running on CDH 5.10 in Archives of Support Questions (Read Only)

Hive query not running on CDH 5.10

Re: Hive query not running on CDH 5.10