hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kumar Jayapal <kjayapa...@gmail.com>
Subject Unable to drop table in HIVE
Date Fri, 29 May 2015 20:38:10 GMT
Hi,

*I get this error when I am trying to drop a table in hive. If any one of
you had seen this issue please help me to resolve it.*


*2015-05-29 20:29:50,755 INFO org.apache.hadoop.hive.ql.log.PerfLogger:
<PERFLOG method=semanticAnalyze from=org.apache.hadoop.hive.ql.Driver>*

*2015-05-29 20:29:50,773 INFO
org.apache.sentry.binding.hive.conf.HiveAuthzConf: DefaultFS:
hdfs://hdfsservice1*

*2015-05-29 20:29:50,787 INFO
org.apache.sentry.binding.hive.conf.HiveAuthzConf: DefaultFS:
hdfs://hdfsservice1*

*2015-05-29 20:29:50,787 WARN
org.apache.sentry.binding.hive.conf.HiveAuthzConf: Using the deprecated
config setting hive.sentry.server instead of sentry.hive.server*

*2015-05-29 20:29:50,787 WARN
org.apache.sentry.binding.hive.conf.HiveAuthzConf: Using the deprecated
config setting hive.sentry.provider instead of sentry.provider*

*2015-05-29 20:29:50,815 ERROR hive.log: error in initSerDe:
java.lang.ClassNotFoundException Class N not found*

*java.lang.ClassNotFoundException: Class N not found*

*        at
org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:1953)*

*        at
org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(MetaStoreUtils.java:343)*

*        at
org.apache.hadoop.hive.ql.metadata.Table.getDeserializerFromMetaStore(Table.java:292)*

*        at
org.apache.hadoop.hive.ql.metadata.Table.getDeserializer(Table.java:285)*

*        at
org.apache.hadoop.hive.ql.metadata.Table.getCols(Table.java:635)*

*        at
org.apache.hadoop.hive.ql.metadata.Table.checkValidity(Table.java:189)*

*        at
org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1041)*

*        at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.getTable(BaseSemanticAnalyzer.java:1172)*

*        at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.getTable(BaseSemanticAnalyzer.java:1156)*

*        at
org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeDropTable(DDLSemanticAnalyzer.java:806)*

*        at
org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeInternal(DDLSemanticAnalyzer.java:282)*

*        at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:204)*

*        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:437)*

*        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335)*

*        at
org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1026)*

*        at
org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1019)*

*        at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:100)*

*        at
org.apache.hive.service.cli.operation.SQLOperation.run(SQLOperation.java:173)*

*        at
org.apache.hive.service.cli.session.HiveSessionImpl.runOperationWithLogCapture(HiveSessionImpl.java:715)*

*        at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:370)*

*        at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:357)*

*        at
org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:237)*

*        at
org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:392)*

*        at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1373)*

*        at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1358)*

*        at
org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)*

*        at
org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)*

*        at
org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:55)*

*        at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244)*

*        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)*

*        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)*

*        at java.lang.Thread.run(Thread.java:745)*

*2015-05-29 20:29:50,816 ERROR org.apache.hadoop.hive.ql.Driver: FAILED:
RuntimeException MetaException(message:java.lang.ClassNotFoundException
Class N not found)*

*java.lang.RuntimeException:
MetaException(message:java.lang.ClassNotFoundException Class N not found)*

*        at
org.apache.hadoop.hive.ql.metadata.Table.getDeserializerFromMetaStore(Table.java:294)*

*        at
org.apache.hadoop.hive.ql.metadata.Table.getDeserializer(Table.java:285)*

*        at
org.apache.hadoop.hive.ql.metadata.Table.getCols(Table.java:635)*

*        at
org.apache.hadoop.hive.ql.metadata.Table.checkValidity(Table.java:189)*

*        at
org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1041)*

*        at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.getTable(BaseSemanticAnalyzer.java:1172)*

*        at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.getTable(BaseSemanticAnalyzer.java:1156)*

*        at
org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeDropTable(DDLSemanticAnalyzer.java:806)*

*        at
org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeInternal(DDLSemanticAnalyzer.java:282)*

*        at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:204)*

*        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:437)*

*        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:335)*

*        at
org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1026)*

*        at
org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1019)*

*        at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:100)*

*        at
org.apache.hive.service.cli.operation.SQLOperation.run(SQLOperation.java:173)*

*        at
org.apache.hive.service.cli.session.HiveSessionImpl.runOperationWithLogCapture(HiveSessionImpl.java:715)*

*        at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:370)*

*        at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:357)*

*        at
org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:237)*

*        at
org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:392)*

*        at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1373)*

*        at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1358)*

*        at
org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)*

*        at
org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)*

*        at
org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:55)*

*        at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244)*

*        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)*

*        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)*

*        at java.lang.Thread.run(Thread.java:745)*

*Caused by: MetaException(message:java.lang.ClassNotFoundException Class N
not found)*

*        at
org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(MetaStoreUtils.java:352)*

*        at
org.apache.hadoop.hive.ql.metadata.Table.getDeserializerFromMetaStore(Table.java:292)*

*        ... 29 more*


*2015-05-29 20:29:50,817 INFO org.apache.hadoop.hive.ql.log.PerfLogger:
</PERFLOG method=compile start=1432931390753 end=1432931390816 duration=63
from=org.apache.hadoop.hive.ql.Driver>*

*2015-05-29 20:29:50,817 INFO org.apache.hadoop.hive.ql.log.PerfLogger:
<PERFLOG method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>*

*2015-05-29 20:29:50,817 INFO org.apache.hadoop.hive.ql.log.PerfLogger:
</PERFLOG method=releaseLocks start=1432931390817 end=1432931390817
duration=0 from=org.apache.hadoop.hive.ql.Driver>*

*2015-05-29 20:29:50,817 WARN
org.apache.hive.service.cli.thrift.ThriftCLIService: Error executing
statement:*

*org.apache.hive.service.cli.HiveSQLException: Error while compiling
statement: FAILED: RuntimeException
MetaException(message:java.lang.ClassNotFoundException Class N not found)*

*        at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:102)*

*        at
org.apache.hive.service.cli.operation.SQLOperation.run(SQLOperation.java:173)*

*        at
org.apache.hive.service.cli.session.HiveSessionImpl.runOperationWithLogCapture(HiveSessionImpl.java:715)*

*        at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:370)*

*        at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:357)*

*        at
org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:237)*

*        at
org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:392)*

*        at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1373)*

*        at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1358)*

*        at
org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)*

*        at
org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)*

*        at
org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:55)*

*        at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244)*

*        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)*

*        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)*

*        at java.lang.Thread.run(Thread.java:745)*







Thanks
Jay

Mime
View raw message