spark2.4.4集成hive3.1.2遇到的一个坑HikariCP

最新推荐文章于 2024-11-18 16:22:01 发布

原创最新推荐文章于 2024-11-18 16:22:01 发布 · 2.2k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#Attempt to invoke the "HikariCP" pl

Spark 同时被 2 个专栏收录

33 篇文章

订阅专栏

Hive

5 篇文章

订阅专栏

本文解决了一个关于HikariCP连接池未在CLASSPATH中找到的问题，通过将datanucleus.connectionPoolingType从HikariCP改为dbcp，成功避免了NucleusException错误。

Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the "HikariCP" plugin to create a ConnectionPool gave an error : The connection pool plugin of type "HikariCP" was not found in the CLASSPATH!
	at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:259)
	at org.datanucleus.store.rdbms.ConnectionFactoryImpl.initialiseDataSources(ConnectionFactoryImpl.java:131)
	at org.datanucleus.store.rdbms.ConnectionFactoryImpl.<init>(ConnectionFactoryImpl.java:85)
	... 148 more
Caused by: org.datanucleus.exceptions.NucleusUserException: The connection pool plugin of type "HikariCP" was not found in the CLASSPATH!
	at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:234)
	... 150 more

解决方案：
将hive-site.xml中的

  <property>
    <name>datanucleus.connectionPoolingType</name>
    <value>Hikari</value>
    <description>
      Expects one of [bonecp, dbcp, hikaricp, none].
      Specify connection pool library for datanucleus
    </description>
  </property>

修改为

  <property>
    <name>datanucleus.connectionPoolingType</name>
    <value>dbcp</value>
    <description>
      Expects one of [bonecp, dbcp, hikaricp, none].
      Specify connection pool library for datanucleus
    </description>
  </property>

即可。
注意：hive和spark中都要修改。