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
