先参考这个
https://blog.csdn.net/weixin_49165958/article/details/108681188
其中 把hive和hadoop的jar包要拷贝到zeppelin的interpreter/jdbc目录下
对于cdh来说，这两个包在 /opt/cloudera/parcels/CDH/jars/ 这个目录下
cp /opt/cloudera/parcels/CDH/jars/hadoop-common-3.0.0-cdh6.2.1 ./interpreter/jdbc/
cp /opt/cloudera/parcels/CDH/jars/hadoop-common-3.0.0-cdh6.2.1.jar ./interpreter/jdbc/
如果出现如下报错，大概率是jar包复制错了
java.lang.NoClassDefFoundError: org/apache/hive/service/rpc/thrift/TCLIService I f a c e a t o r g . a p a c h e . h i v e . j d b c . H i v e D r i v e r . c o n n e c t ( H i v e D r i v e r . j a v a : 107 ) a t j a v a . s q l . D r i v e r M a n a g e r . g e t C o n n e c t i o n ( D r i v e r M a n a g e r . j a v a : 664 ) a t j a v a . s q l . D r i v e r M a n a g e r . g e t C o n n e c t i o n ( D r i v e r M a n a g e r . j a v a : 208 ) a t o r g . a p a c h e . c o m m o n s . d b c p 2. D r i v e r M a n a g e r C o n n e c t i o n F a c t o r y . c r e a t e C o n n e c t i o n ( D r i v e r M a n a g e r C o n n e c t i o n F a c t o r y . j a v a : 79 ) a t o r g . a p a c h e . c o m m o n s . d b c p 2. P o o l a b l e C o n n e c t i o n F a c t o r y . m a k e O b j e c t ( P o o l a b l e C o n n e c t i o n F a c t o r y . j a v a : 205 ) a t o r g . a p a c h e . c o m m o n s . p o o l 2. i m p l . G e n e r i c O b j e c t P o o l . c r e a t e ( G e n e r i c O b j e c t P o o l . j a v a : 836 ) a t o r g . a p a c h e . c o m m o n s . p o o l 2. i m p l . G e n e r i c O b j e c t P o o l . b o r r o w O b j e c t ( G e n e r i c O b j e c t P o o l . j a v a : 434 ) a t o r g . a p a c h e . c o m m o n s . p o o l 2. i m p l . G e n e r i c O b j e c t P o o l . b o r r o w O b j e c t ( G e n e r i c O b j e c t P o o l . j a v a : 361 ) a t o r g . a p a c h e . c o m m o n s . d b c p 2. P o o l i n g D r i v e r . c o n n e c t ( P o o l i n g D r i v e r . j a v a : 129 ) a t j a v a . s q l . D r i v e r M a n a g e r . g e t C o n n e c t i o n ( D r i v e r M a n a g e r . j a v a : 664 ) a t j a v a . s q l . D r i v e r M a n a g e r . g e t C o n n e c t i o n ( D r i v e r M a n a g e r . j a v a : 270 ) a t o r g . a p a c h e . z e p p e l i n . j d b c . J D B C I n t e r p r e t e r . g e t C o n n e c t i o n F r o m P o o l ( J D B C I n t e r p r e t e r . j a v a : 490 ) a t o r g . a p a c h e . z e p p e l i n . j d b c . J D B C I n t e r p r e t e r . g e t C o n n e c t i o n ( J D B C I n t e r p r e t e r . j a v a : 512 ) a t o r g . a p a c h e . z e p p e l i n . j d b c . J D B C I n t e r p r e t e r . e x e c u t e S q l ( J D B C I n t e r p r e t e r . j a v a : 698 ) a t o r g . a p a c h e . z e p p e l i n . j d b c . J D B C I n t e r p r e t e r . i n t e r n a l I n t e r p r e t ( J D B C I n t e r p r e t e r . j a v a : 877 ) a t o r g . a p a c h e . z e p p e l i n . i n t e r p r e t e r . A b s t r a c t I n t e r p r e t e r . i n t e r p r e t ( A b s t r a c t I n t e r p r e t e r . j a v a : 47 ) a t o r g . a p a c h e . z e p p e l i n . i n t e r p r e t e r . L a z y O p e n I n t e r p r e t e r . i n t e r p r e t ( L a z y O p e n I n t e r p r e t e r . j a v a : 110 ) a t o r g . a p a c h e . z e p p e l i n . i n t e r p r e t e r . r e m o t e . R e m o t e I n t e r p r e t e r S e r v e r Iface at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:79) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:836) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:434) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:361) at org.apache.commons.dbcp2.PoolingDriver.connect(PoolingDriver.java:129) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270) at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnectionFromPool(JDBCInterpreter.java:490) at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:512) at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:698) at org.apache.zeppelin.jdbc.JDBCInterpreter.internalInterpret(JDBCInterpreter.java:877) at org.apache.zeppelin.interpreter.AbstractInterpreter.interpret(AbstractInterpreter.java:47) at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:110) at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer Ifaceatorg.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)atjava.sql.DriverManager.getConnection(DriverManager.java:664)atjava.sql.DriverManager.getConnection(DriverManager.java:208)atorg.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:79)atorg.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205)atorg.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:836)atorg.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:434)atorg.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:361)atorg.apache.commons.dbcp2.PoolingDriver.connect(PoolingDriver.java:129)atjava.sql.DriverManager.getConnection(DriverManager.java:664)atjava.sql.DriverManager.getConnection(DriverManager.java:270)atorg.apache.zeppelin.jdbc.JDBCInterpreter.getConnectionFromPool(JDBCInterpreter.java:490)atorg.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:512)atorg.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:698)atorg.apache.zeppelin.jdbc.JDBCInterpreter.internalInterpret(JDBCInterpreter.java:877)atorg.apache.zeppelin.interpreter.AbstractInterpreter.interpret(AbstractInterpreter.java:47)atorg.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:110)atorg.apache.zeppelin.interpreter.remote.RemoteInterpreterServerInterpretJob.jobRun(RemoteInterpreterServer.java:852)
at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer I n t e r p r e t J o b . j o b R u n ( R e m o t e I n t e r p r e t e r S e r v e r . j a v a : 744 ) a t o r g . a p a c h e . z e p p e l i n . s c h e d u l e r . J o b . r u n ( J o b . j a v a : 172 ) a t o r g . a p a c h e . z e p p e l i n . s c h e d u l e r . A b s t r a c t S c h e d u l e r . r u n J o b ( A b s t r a c t S c h e d u l e r . j a v a : 132 ) a t o r g . a p a c h e . z e p p e l i n . s c h e d u l e r . P a r a l l e l S c h e d u l e r . l a m b d a InterpretJob.jobRun(RemoteInterpreterServer.java:744) at org.apache.zeppelin.scheduler.Job.run(Job.java:172) at org.apache.zeppelin.scheduler.AbstractScheduler.runJob(AbstractScheduler.java:132) at org.apache.zeppelin.scheduler.ParallelScheduler.lambda InterpretJob.jobRun(RemoteInterpreterServer.java:744)atorg.apache.zeppelin.scheduler.Job.run(Job.java:172)atorg.apache.zeppelin.scheduler.AbstractScheduler.runJob(AbstractScheduler.java:132)atorg.apache.zeppelin.scheduler.ParallelScheduler.lambdarunJobInScheduler 0 ( P a r a l l e l S c h e d u l e r . j a v a : 46 ) a t j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r . r u n W o r k e r ( T h r e a d P o o l E x e c u t o r . j a v a : 1149 ) a t j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r 0(ParallelScheduler.java:46) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor 0(ParallelScheduler.java:46)atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)atjava.util.concurrent.ThreadPoolExecutorWorker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: org.apache.hive.service.rpc.thrift.TCLIService I f a c e a t j a v a . n e t . U R L C l a s s L o a d e r . f i n d C l a s s ( U R L C l a s s L o a d e r . j a v a : 382 ) a t j a v a . l a n g . C l a s s L o a d e r . l o a d C l a s s ( C l a s s L o a d e r . j a v a : 424 ) a t s u n . m i s c . L a u n c h e r Iface at java.net.URLClassLoader.findClass(URLClassLoader.java:382) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher Ifaceatjava.net.URLClassLoader.findClass(URLClassLoader.java:382)atjava.lang.ClassLoader.loadClass(ClassLoader.java:424)atsun.misc.LauncherAppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
… 25 more
2540
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
