hive classnotfoundexception，即使所有JAR都添加到maven存储库中

qnzebej0  于 2021-05-29  发布在  Hadoop
关注(0)|答案(2)|浏览(561)

我添加了该项目所需的所有jar，但我无法解决此异常。是否有人对此提出建议。你能告诉我如何授予配置单元数据库访问权限吗。提前谢谢。

  1. java.lang.ClassNotFoundException: org.apache.hadoop.hive.jdbc.HiveDriver
  2.     at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
  3.     at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
  4.     at java.security.AccessController.doPrivileged(Native Method)
  5.     at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
  6.     at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
  7.     at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
  8.     at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
  9.     at java.lang.Class.forName0(Native Method)
  10.     at java.lang.Class.forName(Class.java:190)
  11.     at org.ezytruk.com.CreateHiveExternalTable.createHiveExternalTable(CreateHiveExternalTable.java:20)
  12.     at org.ezytruk.com.CreateHiveExternalTable.main(CreateHiveExternalTable.java:53)
  13. Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:hive://localhost/EZYTRUK
  14.     at java.sql.DriverManager.getConnection(DriverManager.java:596)
  15.     at java.sql.DriverManager.getConnection(DriverManager.java:215)
  16.     at org.ezytruk.com.CreateHiveExternalTable.createHiveExternalTable(CreateHiveExternalTable.java:39)
  17.     at org.ezytruk.com.CreateHiveExternalTable.main(CreateHiveExternalTable.java:53)

pom.xml文件

  1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  2.   <modelVersion>4.0.0</modelVersion>
  3.   <groupId>BigData</groupId>
  4.   <artifactId>BigData</artifactId>
  5.   <version>0.0.1-SNAPSHOT</version>
  6.   <properties>
  7.   <slf4j.version>1.6.1</slf4j.version>
  8.   <hadoop-version>2.6.0</hadoop-version>
  9.   <mysql-connector-version>5.1.40</mysql-connector-version>
  10.   <sqoop-core-version>1.99.3</sqoop-core-version>
  11.   <zookeeper-version>3.4.9</zookeeper-version>
  12.   <hive-jdbc-version>1.2.1</hive-jdbc-version>
  13.   <commons-io-version>2.2</commons-io-version>
  14.   <commons-logging.version>1.2</commons-logging.version>
  15.   </properties>
  16.   <dependencies>
  17.   <dependency>
  18.     <groupId>commons-io</groupId>
  19.     <artifactId>commons-io</artifactId>
  20.     <version>${commons-io-version}</version>
  21. </dependency>
  22.  <dependency>
  23.         <groupId>commons-logging</groupId>
  24.         <artifactId>commons-logging</artifactId>
  25.         <version>${commons-logging.version}</version>
  26.    </dependency>        
  27.    <dependency>
  28.     <groupId>mysql</groupId>
  29.     <artifactId>mysql-connector-java</artifactId>
  30.     <version>${mysql-connector-version}</version>
  31.    </dependency>
  32.   <dependency>
  33.     <groupId>org.apache.hadoop</groupId>
  34.     <artifactId>hadoop-common</artifactId>
  35.     <version>${hadoop-version}</version>
  36. </dependency>
  37.   <dependency>
  38.     <groupId>org.apache.hadoop</groupId>
  39.     <artifactId>hadoop-client</artifactId>
  40.     <version>${hadoop-version}</version>
  41. </dependency>
  42.   <dependency>
  43.     <groupId>org.apache.hadoop</groupId>
  44.     <artifactId>hadoop-hdfs</artifactId>
  45.     <version>${hadoop-version}</version>
  46. </dependency>
  47.   <dependency>
  48.     <groupId>org.apache.hadoop</groupId>
  49.     <artifactId>hadoop-mapreduce-client-core</artifactId>
  50.     <version>${hadoop-version}</version>
  51. </dependency>
  52.   <dependency>
  53.     <groupId>org.apache.hadoop</groupId>
  54.     <artifactId>hadoop-yarn-common</artifactId>
  55.     <version>${hadoop-version}</version>
  56. </dependency>
  57.  <dependency>
  58.     <groupId>org.apache.hadoop</groupId>
  59.     <artifactId>hadoop-core</artifactId>
  60.     <version>1.2.1</version>
  61. </dependency>
  62.  <dependency> 
  63.     <groupId>org.apache.sqoop</groupId>
  64.     <artifactId>sqoop-core</artifactId>
  65.     <version>${sqoop-core-version}</version>
  66. </dependency>
  67. <dependency>
  68.     <groupId>org.apache.sqoop</groupId>
  69.     <artifactId>sqoop-client</artifactId>
  70.     <version>${sqoop-core-version}</version>
  71. </dependency>
  72. <dependency>
  73.     <groupId>org.apache.sqoop</groupId>
  74.     <artifactId>sqoop-common</artifactId>
  75.     <version>${sqoop-core-version}</version>
  76. </dependency>
  77. <dependency>
  78.     <groupId>org.apache.sqoop.connector</groupId>
  79.     <artifactId>sqoop-connector-generic-jdbc</artifactId>
  80.     <version>${sqoop-core-version}</version>
  81. </dependency>
  82. <dependency>
  83.     <groupId>org.apache.sqoop</groupId>
  84.     <artifactId>sqoop</artifactId>
  85.     <version>1.4.1-incubating</version>
  86. </dependency>
  87. <dependency>
  88.     <groupId>org.apache.zookeeper</groupId>
  89.     <artifactId>zookeeper</artifactId>
  90.     <version>${zookeeper-version}</version>
  91. </dependency>
  93. <dependency>
  94.     <groupId>org.apache.hive</groupId>
  95.     <artifactId>hive-jdbc</artifactId>
  96.     <version>${hive-jdbc-version}</version>
  97. </dependency>
  98. <dependency>
  99.     <groupId>org.apache.hive</groupId>
  100.     <artifactId>hive-exec</artifactId>
  101.     <version>${hive-jdbc-version}</version>
  102. </dependency>
  104. <dependency>
  105.     <groupId>org.apache.hive</groupId>
  106.     <artifactId>hive-metastore</artifactId>
  107.     <version>${hive-jdbc-version}</version>
  108. </dependency>
  109. <dependency>
  110.     <groupId>org.apache.hive</groupId>
  111.     <artifactId>hive-common</artifactId>
  112.     <version>${hive-jdbc-version}</version>
  113. </dependency>
  114. <dependency>
  115.     <groupId>org.apache.hive</groupId>
  116.     <artifactId>hive-service</artifactId>
  117.     <version>${hive-jdbc-version}</version>
  118. </dependency>
  119. <dependency>
  120.     <groupId>org.apache.hive</groupId>
  121.     <artifactId>hive-shims</artifactId>
  122.     <version>${hive-jdbc-version}</version>
  123. </dependency>
  124. <dependency>
  125.     <groupId>org.apache.hive</groupId>
  126.     <artifactId>hive-serde</artifactId>
  127.     <version>${hive-jdbc-version}</version>
  128. </dependency>
  130. </dependencies>
  131.   <packaging>war</packaging>
  132.   <build>
  133.     <sourceDirectory>src</sourceDirectory>
  134.     <plugins>
  135.       <plugin>
  136.         <artifactId>maven-compiler-plugin</artifactId>
  137.         <version>3.3</version>
  138.         <configuration>
  139.           <source>1.7</source>
  140.           <target>1.7</target>
  141.         </configuration>
  142.       </plugin>
  143.       <plugin>
  144.         <artifactId>maven-war-plugin</artifactId>
  145.         <version>2.6</version>
  146.         <configuration>
  147.           <warSourceDirectory>WebContent</warSourceDirectory>
  148.         </configuration>
  149.       </plugin>
  150.     </plugins>
  151.   </build>
  152. </project>

课程：

  1. package org.hive.com;
  3.     import java.io.FileNotFoundException;
  4.     import java.io.IOException;
  5.     import java.sql.Connection;
  6.     import java.sql.DriverManager;
  7.     import java.sql.SQLException;
  9.     import org.apache.hadoop.conf.Configuration;
  10.     import org.apache.hadoop.fs.Path;
  12.     import com.mysql.jdbc.Statement;
  14.     public class CreateHiveExternalTable {
  16.         public static String driverName = "org.apache.hadoop.hive.jdbc.HiveDriver";
  18.         public static void createHiveExternalTable() throws FileNotFoundException, IOException, SQLException {
  19.             try {
  20.                 Class.forName(driverName);
  21.             } catch (ClassNotFoundException e) {
  22.                 // TODO Auto-generated catch block
  23.                 e.printStackTrace();
  24.             }
  26.             Configuration config = new Configuration();
  27.             config.addResource(new Path("/usr/local/hadoop/etc/hadoop/conf/core-site.xml"));
  28.             config.addResource(new Path("/usr/local/hadoop/etc/hadoop/conf/hdfs-site.xml"));
  30.         Connection connect = DriverManager.getConnection("jdbc:hive://localhost/hivedb","hive","");
  31.             Statement stmt = (Statement) connect.createStatement();
  32.             //String tableName = properties.getProperty("hive_table_name");
  33.             stmt.executeQuery("CREATE EXTERNAL TABLE IF NOT EXISTS"
  34.              +"SHIPPER(S_ID INT,S_NAME VARCHAR(100),S_ADDR VARCHAR(100),S_CITY VARCHAR(100)"
  35.              +"ROW FORMAT DELIMITED FIELDS TERMINATED BY ','"
  36.              +"LOCATION 'hdfs://localhost://hive'");
  38.             System.out.println("Table created.");
  39.             connect.close();
  40.         }
  42.          public static void main(String[] args) throws FileNotFoundException, IOException, SQLException{
  43.              CreateHiveExternalTable hiveTable = new CreateHiveExternalTable();
  44.              hiveTable.createHiveExternalTable();
  45.          }     
  47.         }
JavahadoopmysqlHive

2条答案

按热度按时间
qlfbtfca

qlfbtfca1#

从这个post使用jdbc从java连接到hive
尝试

  1. private static String driverName = "org.apache.hive.jdbc.HiveDriver"

而不是

  1. private static String driverName = "org.apache.hadoop.hive.jdbc.HiveDriver";

我希望你补充说 Class.forName(driverName) 代码中的语句
也：

  1. Connection connect = DriverManager.getConnection("jdbc:hive2://localhost:HIVEPORT/hivedb","hive","");

而不是

  1. Connection connect = DriverManager.getConnection("jdbc:hive://localhost/hivedb","hive","");

我不知道你运行的是哪个端口，但是记住要改变这条线路

  1. localhost:HIVEPORT
展开查看全部
赞(0）分享  回复(0）举报  2021-05-30
bmp9r5qi

bmp9r5qi2#

hive.server2.thrift.port是可以检查端口的属性。
在配置单元外壳上，给出命令“set hive.server2.thrift.port”，这将给出配置单元的端口号
默认情况下，配置单元端口设置为10000，但您可以在配置单元外壳上使用上述命令进行检查。。

赞(0）分享  回复(0）举报  2021-05-29
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com