Re: can't execute hive queries

[mohammed vasim]

I think this is because of extent of limit like (10000,1000 etc).Hue console can't more records. It will show this error.Please restart your hive service to get rid of this error.

If you want to do a query on million records it better to do from hive command line.

On Thursday, August 11, 2016, baboya <joel.m...@gmail.com> wrote:

i'm getting the following errors below when executing hive queries from the hive editor.. can someone please point out what i'm missing or any config changes that will help resolve this? thanks

[11/Aug/2016 18:21:24 +0000] api          WARNING  Autocomplete data fetching error: Bad status for request TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret='\xedD\xa4\x86\xf6\xe4G\xc8\xa2\x02\x8d\x07F\xea\xba\xbb', guid='\xe6\xfc\x1a\xcd\x153@+\xad+\xa3\xd8\xf7\xf0D\xbb')), orientation=0, maxRows=5000):

TFetchResultsResp(status=TStatus(errorCode=0, errorMessage="java.io.IOException: java.io.IOException: Can't get Master Kerberos principal for use as renewer", sqlState=None, infoMessages=["*org.apache.hive.service.cli.HiveSQLException:java.io.IOException: java.io.IOException: Can't get Master Kerberos principal for use as renewer:25:24", 'org.apache.hive.service.cli.operation.SQLOperation:getNextRowSet:SQLOperation.java:352', 'org.apache.hive.service.cli.operation.OperationManager:getOperationNextRowSet:OperationManager.java:223', 'org.apache.hive.service.cli.session.HiveSessionImpl:fetchResults:HiveSessionImpl.java:716', 'sun.reflect.GeneratedMethodAccessor35:invoke::-1', 'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43', 'java.lang.reflect.Method:invoke:Method.java:498', '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:422', 'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1657', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59', 'com.sun.proxy.$Proxy20:fetchResults::-1', 'org.apache.hive.service.cli.CLIService:fetchResults:CLIService.java:454', 'org.apache.hive.service.cli.thrift.ThriftCLIService:FetchResults:ThriftCLIService.java:672', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults:getResult:TCLIService.java:1557', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults:getResult:TCLIService.java:1542', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor:process:HadoopThriftAuthBridge.java:692', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:285', 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1142', 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:617', 'java.lang.Thread:run:Thread.java:745', "*java.io.IOException:java.io.IOException: Can't get Master Kerberos principal for use as renewer:29:4", 'org.apache.hadoop.hive.ql.exec.FetchOperator:getNextRow:FetchOperator.java:512', 'org.apache.hadoop.hive.ql.exec.FetchOperator:pushRow:FetchOperator.java:419', 'org.apache.hadoop.hive.ql.exec.FetchTask:fetch:FetchTask.java:143', 'org.apache.hadoop.hive.ql.Driver:getResults:Driver.java:1737', 'org.apache.hive.service.cli.operation.SQLOperation:getNextRowSet:SQLOperation.java:347', "*java.io.IOException:Can't get Master Kerberos principal for use as renewer:36:7", 'org.apache.hadoop.mapreduce.security.TokenCache:obtainTokensForNamenodesInternal:TokenCache.java:116', 'org.apache.hadoop.mapreduce.security.TokenCache:obtainTokensForNamenodesInternal:TokenCache.java:100', 'org.apache.hadoop.mapreduce.security.TokenCache:obtainTokensForNamenodes:TokenCache.java:80', 'org.apache.hadoop.mapred.FileInputFormat:listStatus:FileInputFormat.java:206', 'org.apache.hadoop.mapred.FileInputFormat:getSplits:FileInputFormat.java:315', 'org.apache.hadoop.hive.ql.exec.FetchOperator:getNextSplits:FetchOperator.java:367', 'org.apache.hadoop.hive.ql.exec.FetchOperator:getRecordReader:FetchOperator.java:299', 'org.apache.hadoop.hive.ql.exec.FetchOperator:getNextRow:FetchOperator.java:450'], statusCode=3), results=None, hasMoreRows=None)

--
You received this message because you are subscribed to the Google Groups "Hue-Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+unsubscribe@cloudera.org.

[Romain Rigaux]

"Can't get Master Kerberos principal for use as renewer" Looks like a Kerberos misconfiguration in Yarn or Hive