Zeppelin Phoenix NoSuchMethodError

jgeorge — Mon, 20 Feb 2017 00:48:15 GMT

Hi,

While Trying to execute phoenix queries via zeppelin in HDP-2.5 Sandbox, I am getting below NoSuchMethodError. I enabled Phoenix and turned Auth to simple in Hbase conf. Please let me know if I am missing something here (ranger is disabled and not Kerberized):

04:50:05.006 [pool-3-thread-2] ERROR org.apache.zeppelin.jdbc.security.JDBCSecurityImpl - Invalid auth.type detected with value , defaulting auth.type to SIMPLE org.apache.phoenix.exception.PhoenixIOException: java.lang.NoSuchMethodError: org.apache.hadoop.hbase.protobuf.generated.MasterProtos$ModifyTableRequest$Builder.setNonceGroup(J)Lorg/apache/hadoop/hbase/protobuf/generated/MasterProtos$ModifyTableRequest$Builder; at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:111) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1063) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1369) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2116) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:828) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:338) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:326) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:324) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1326) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2436) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2248) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2248) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:233) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:135) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_111] at java.sql.DriverManager.getConnection(DriverManager.java:208) ~[?:1.8.0_111] at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:257) ~[zeppelin-jdbc-0.6.0.2.5.0.0-1245.jar:0.6.0.2.5.0.0-1245] at org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(JDBCInterpreter.java:275) ~[zeppelin-jdbc-0.6.0.2.5.0.0-1245.jar:0.6.0.2.5.0.0-1245] at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:336) [zeppelin-jdbc-0.6.0.2.5.0.0-1245.jar:0.6.0.2.5.0.0-1245] at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:442) [zeppelin-jdbc-0.6.0.2.5.0.0-1245.jar:0.6.0.2.5.0.0-1245] at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94) [zeppelin-interpreter-0.6.0.2.5.0.0-1245.jar:0.6.0.2.5.0.0-1245] at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341) [zeppelin-interpreter-0.6.0.2.5.0.0-1245.jar:0.6.0.2.5.0.0-1245] at org.apache.zeppelin.scheduler.Job.run(Job.java:176) [zeppelin-interpreter-0.6.0.2.5.0.0-1245.jar:0.6.0.2.5.0.0-1245] at org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162) [zeppelin-interpreter-0.6.0.2.5.0.0-1245.jar:0.6.0.2.5.0.0-1245] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_111] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_111] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_111] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_111] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_111] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_111] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_111] Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.NoSuchMethodError: org.apache.hadoop.hbase.protobuf.generated.MasterProtos$ModifyTableRequest$Builder.setNonceGroup(J)Lorg/apache/hadoop/hbase/protobuf/generated/MasterProtos$ModifyTableRequest$Builder; at org.apache.hadoop.hbase.client.RpcRetryingCaller.translateException(RpcRetryingCaller.java:229) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:140) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.hadoop.hbase.client.HBaseAdmin.executeCallable(HBaseAdmin.java:4036) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.hadoop.hbase.client.HBaseAdmin.modifyTable(HBaseAdmin.java:2548) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.hadoop.hbase.client.HBaseAdmin.modifyTable(HBaseAdmin.java:2561) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.phoenix.query.ConnectionQueryServicesImpl.modifyTable(ConnectionQueryServicesImpl.java:1086) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1058) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] ... 33 more Caused by: java.lang.NoSuchMethodError: org.apache.hadoop.hbase.protobuf.generated.MasterProtos$ModifyTableRequest$Builder.setNonceGroup(J)Lorg/apache/hadoop/hbase/protobuf/generated/MasterProtos$ModifyTableRequest$Builder; at org.apache.hadoop.hbase.protobuf.RequestConverter.buildModifyTableRequest(RequestConverter.java:1298) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.hadoop.hbase.client.HBaseAdmin$25.call(HBaseAdmin.java:2551) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.hadoop.hbase.client.HBaseAdmin$25.call(HBaseAdmin.java:2548) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.hadoop.hbase.client.HBaseAdmin.executeCallable(HBaseAdmin.java:4036) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.hadoop.hbase.client.HBaseAdmin.modifyTable(HBaseAdmin.java:2548) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.hadoop.hbase.client.HBaseAdmin.modifyTable(HBaseAdmin.java:2561) ~[hbase-client-1.1.3.jar:1.1.3] at org.apache.phoenix.query.ConnectionQueryServicesImpl.modifyTable(ConnectionQueryServicesImpl.java:1086) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1058) ~[phoenix-core-4.7.0-HBase-1.1.jar:4.7.0-HBase-1.1] ... 33 more

Thanks,

Jobin George

Re: Zeppelin Phoenix NoSuchMethodError

elserj — Tue, 21 Feb 2017 23:28:30 GMT

It would appear that Zeppelin is including an invalid version of an HBase jar on the classpath.

Caused by: java.lang.NoSuchMethodError: 
org.apache.hadoop.hbase.protobuf.generated.MasterProtos$ModifyTableRequest$Builder.setNonceGroup(J)Lorg/apache/hadoop/hbase/protobuf/generated/MasterProtos$ModifyTableRequest$Builder

Re: Zeppelin Phoenix NoSuchMethodError

jgeorge — Wed, 22 Feb 2017 02:13:24 GMT

Hi @Josh Elser,

I was wondering why there could be an invalid version of Hbase Jar in the class path of a Sanbox, I havnt changed any configs. Also what is the best approach to fix this?

Thanks,

Jobin

Re: Zeppelin Phoenix NoSuchMethodError

jgeorge — Wed, 03 May 2017 20:09:26 GMT

Thanks Josh. removing and re-installing zeppelin did the trick. missed to accept the answer.

question Re: Zeppelin Phoenix NoSuchMethodError in Archives of Support Questions (Read Only)

Zeppelin Phoenix NoSuchMethodError

Re: Zeppelin Phoenix NoSuchMethodError

Re: Zeppelin Phoenix NoSuchMethodError

Re: Zeppelin Phoenix NoSuchMethodError