You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hadoop.apache.org by Kumar Jayapal <kj...@gmail.com> on 2015/05/29 22:38:10 UTC
Unable to drop table in HIVE
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
Re: Unable to drop table in HIVE
Posted by Kumar Jayapal <kj...@gmail.com>.
Hello Ruvi,
Thanks for your prompt response. I tried adding the jar file to hive. My
cluster is sentry enabled. I get insufficient privileges when I try to add
jar.
Thanks
Sajid
Thanks
Jay
On Fri, May 29, 2015 at 2:19 PM, P lva <ru...@gmail.com> wrote:
> If you created this table with a custom serde, you would need to load the
> jar into environment before you drop the table.
>
> Thanks
> Ruvi
>
Re: Unable to drop table in HIVE
Posted by Kumar Jayapal <kj...@gmail.com>.
Hello Ruvi,
Thanks for your prompt response. I tried adding the jar file to hive. My
cluster is sentry enabled. I get insufficient privileges when I try to add
jar.
Thanks
Sajid
Thanks
Jay
On Fri, May 29, 2015 at 2:19 PM, P lva <ru...@gmail.com> wrote:
> If you created this table with a custom serde, you would need to load the
> jar into environment before you drop the table.
>
> Thanks
> Ruvi
>
Re: Unable to drop table in HIVE
Posted by Kumar Jayapal <kj...@gmail.com>.
Hello Ruvi,
Thanks for your prompt response. I tried adding the jar file to hive. My
cluster is sentry enabled. I get insufficient privileges when I try to add
jar.
Thanks
Sajid
Thanks
Jay
On Fri, May 29, 2015 at 2:19 PM, P lva <ru...@gmail.com> wrote:
> If you created this table with a custom serde, you would need to load the
> jar into environment before you drop the table.
>
> Thanks
> Ruvi
>
Re: Unable to drop table in HIVE
Posted by Kumar Jayapal <kj...@gmail.com>.
Hello Ruvi,
Thanks for your prompt response. I tried adding the jar file to hive. My
cluster is sentry enabled. I get insufficient privileges when I try to add
jar.
Thanks
Sajid
Thanks
Jay
On Fri, May 29, 2015 at 2:19 PM, P lva <ru...@gmail.com> wrote:
> If you created this table with a custom serde, you would need to load the
> jar into environment before you drop the table.
>
> Thanks
> Ruvi
>
Re: Unable to drop table in HIVE
Posted by P lva <ru...@gmail.com>.
If you created this table with a custom serde, you would need to load the
jar into environment before you drop the table.
Thanks
Ruvi
Re: Unable to drop table in HIVE
Posted by P lva <ru...@gmail.com>.
If you created this table with a custom serde, you would need to load the
jar into environment before you drop the table.
Thanks
Ruvi
Re: Unable to drop table in HIVE
Posted by P lva <ru...@gmail.com>.
If you created this table with a custom serde, you would need to load the
jar into environment before you drop the table.
Thanks
Ruvi
Re: Unable to drop table in HIVE
Posted by P lva <ru...@gmail.com>.
If you created this table with a custom serde, you would need to load the
jar into environment before you drop the table.
Thanks
Ruvi