大数据学习(12)—— Hive Server2服务
阅读原文时间:2022年05月04日阅读:1

上一篇我们启动了hive --service metastore服务,可以通过命令行来访问hive服务,但是它不支持多客户端同时访问,参见官网说明:HiveServer cannot handle concurrent requests from more than one client. 。

那么什么是Hive Server2呢?看看官网定义:HiveServer2 (HS2) is a service that enables clients to execute queries against Hive. HiveServer2 is the successor to HiveServer1 which has been deprecated. HS2 supports multi-client concurrency and authentication.

Hive Server2的客户端访问服务时,需要HDFS的超级用户权限。修改core-site.xml配置,新增如下配置项。

<property>  
    <name>hadoop.proxyuser.hadoop.groups</name>  
    <value>\*</value>  
</property>  
<property>  
    <name>hadoop.proxyuser.hadoop.hosts</name>  
    <value>\*</value>  
</property>

重启hadoop集群,或者在namenode节点刷新配置

hdfs dfsadmin -fs hdfs://server01:8020 -refreshSuperUserGroupsConfiguration
hdfs dfsadmin -fs hdfs://server02:8020 -refreshSuperUserGroupsConfiguration

在server03上启动hiveserver2,这也是个阻塞式窗口,不要等它退回命令行了。

[hadoop@server03 ~]$ hiveserver2
which: no hbase in (/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/usr/java/jdk1.8.0/bin:/usr/apache-zookeeper-3.5.8/bin:/usr/hadoop-3.3.0/bin:/usr/hadoop-3.3.0/sbin:/usr/apache-hive-3.1.2/bin:/home/hadoop/.local/bin:/home/hadoop/bin)
2020-11-05 12:57:33: Starting HiveServer2
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/apache-hive-3.1.2/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hadoop-3.3.0/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Hive Session ID = 3d80adcc-a6f1-4169-a978-e0333adda98c
Hive Session ID = 00604d67-6b34-40c1-b7a0-3ef567729821

在server02上启动beeline客户端,语法是beeline -u url -n username

[hadoop@server02 ~]$ beeline -u jdbc:hive2://server03:10000/test -n hadoop
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/apache-hive-3.1.2/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hadoop-3.3.0/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Connecting to jdbc:hive2://server03:10000/test
Connected to: Apache Hive (version 3.1.2)
Driver: Hive JDBC (version 3.1.2)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 3.1.2 by Apache Hive
0: jdbc:hive2://server03:10000/test>

试着做几个查询,看看结果。从输出结果可以看到,它默认输出了表头信息,不需要做额外的设置。

0: jdbc:hive2://server03:10000/test> show tables;
INFO : Compiling command(queryId=hadoop_20201105130410_fc4b7b23-99b4-4756-8226-2462e6f07d3e): show tables
INFO : Concurrency mode is disabled, not creating a lock manager
INFO : Semantic Analysis Completed (retrial = false)
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from deserializer)], properties:null)
INFO : Completed compiling command(queryId=hadoop_20201105130410_fc4b7b23-99b4-4756-8226-2462e6f07d3e); Time taken: 3.008 seconds
INFO : Concurrency mode is disabled, not creating a lock manager
INFO : Executing command(queryId=hadoop_20201105130410_fc4b7b23-99b4-4756-8226-2462e6f07d3e): show tables
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing command(queryId=hadoop_20201105130410_fc4b7b23-99b4-4756-8226-2462e6f07d3e); Time taken: 2.923 seconds
INFO : OK
INFO : Concurrency mode is disabled, not creating a lock manager
+------------+
| tab_name |
+------------+
| hive1 |
| hive1_mid |
+------------+
2 rows selected (8.343 seconds)
0: jdbc:hive2://server03:10000/test> select * from hive1_mid;
INFO : Compiling command(queryId=hadoop_20201105130432_de6a9f65-796a-4056-98e0-7275ce206382): select * from hive1_mid
INFO : Concurrency mode is disabled, not creating a lock manager
INFO : Semantic Analysis Completed (retrial = false)
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:hive1_mid.year, type:string, comment:null), FieldSchema(name:hive1_mid.month, type:string, comment:null), FieldSchema(name:hive1_mid.day, type:string, comment:null), FieldSchema(name:hive1_mid.temperature, type:smallint, comment:null)], properties:null)
INFO : Completed compiling command(queryId=hadoop_20201105130432_de6a9f65-796a-4056-98e0-7275ce206382); Time taken: 7.958 seconds
INFO : Concurrency mode is disabled, not creating a lock manager
INFO : Executing command(queryId=hadoop_20201105130432_de6a9f65-796a-4056-98e0-7275ce206382): select * from hive1_mid
INFO : Completed executing command(queryId=hadoop_20201105130432_de6a9f65-796a-4056-98e0-7275ce206382); Time taken: 0.356 seconds
INFO : OK
INFO : Concurrency mode is disabled, not creating a lock manager
+-----------------+------------------+----------------+------------------------+
| hive1_mid.year | hive1_mid.month | hive1_mid.day | hive1_mid.temperature |
+-----------------+------------------+----------------+------------------------+
| 1949 | 10 | 01 | 38 |
| 1949 | 10 | 02 | 36 |
| 1950 | 01 | 01 | 32 |
| 1950 | 10 | 01 | 37 |
| 1950 | 10 | 02 | 41 |
| 1950 | 10 | 03 | 27 |
| 1951 | 07 | 01 | 45 |
| 1951 | 07 | 02 | 46 |
| 1951 | 07 | 03 | 47 |
| 1951 | 12 | 01 | 23 |
+-----------------+------------------+----------------+------------------------+
10 rows selected (11.496 seconds)

新建一个maven工程。在src下创建resources目录,标记为resoure root,放入相关配置文件。结构非常简单。

在pom中引入依赖。

<!-- https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc -->  
<dependency>  
  <groupId>org.apache.hive</groupId>  
  <artifactId>hive-jdbc</artifactId>  
  <version>3.1.2</version>  
</dependency>

<!-- https://mvnrepository.com/artifact/org.apache.hadoop/hadoop-common -->  
<dependency>  
  <groupId>org.apache.hadoop</groupId>  
  <artifactId>hadoop-common</artifactId>  
  <version>3.3.0</version>  
</dependency>

这两个依赖会下载很多jar包,引起大量jar包冲突,不管他。

新建HiveClient类,代码如下

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

/\*\*  
 \* @param args  
 \* @throws SQLException  
 \*/  
public static void main(String\[\] args) throws SQLException {  
    try {  
        Class.forName(driverName);  
    } catch (ClassNotFoundException e) {  
        // TODO Auto-generated catch block  
        e.printStackTrace();  
        System.exit(1);  
    }  
    //replace "hive" here with the name of the user the queries should run as  
    Connection con = DriverManager.getConnection("jdbc:hive2://server03:10000/test", "hadoop", "");  
    Statement stmt = con.createStatement();  
    String tableName = "hive1\_mid";

    // describe table  
    String sql = "describe " + tableName;  
    System.out.println("Running: " + sql);  
    ResultSet res = stmt.executeQuery(sql);  
    while (res.next()) {  
        System.out.println(res.getString(1) + "\\t" + res.getString(2));  
    }

    // select \* query  
    sql = "select \* from " + tableName;  
    System.out.println("Running: " + sql);  
    res = stmt.executeQuery(sql);  
    while (res.next()) {  
        System.out.println(String.valueOf(res.getInt(1)) + "\\t" + res.getString(2)+ "\\t" +res.getString(3)+ "\\t" +res.getString(4));  
    }

    // regular hive query  
    sql = "select count(1) from " + tableName;  
    System.out.println("Running: " + sql);  
    res = stmt.executeQuery(sql);  
    while (res.next()) {  
        System.out.println(res.getString(1));  
    }  
}

在IDEA中执行,控制台输出结果如下

"C:\Program Files\Java\jdk1.8.0_271\bin\java.exe" "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2019.2.4\lib\idea_rt.jar=61314:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2019.2.4\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_271\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_271\jre\lib\rt.jar;D:\IDEAProject\hivetest\target\classes;C:\Users\cq\.m2\repository\org\apache\hive\hive-jdbc\3.1.2\hive-jdbc-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-common\3.1.2\hive-common-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-classification\3.1.2\hive-classification-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-storage-api\2.7.0\hive-storage-api-2.7.0.jar;C:\Users\cq\.m2\repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;C:\Users\cq\.m2\repository\org\apache\orc\orc-core\1.5.6\orc-core-1.5.6.jar;C:\Users\cq\.m2\repository\org\apache\orc\orc-shims\1.5.6\orc-shims-1.5.6.jar;C:\Users\cq\.m2\repository\io\airlift\aircompressor\0.10\aircompressor-0.10.jar;C:\Users\cq\.m2\repository\javax\xml\bind\jaxb-api\2.2.11\jaxb-api-2.2.11.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-hdfs\2.2.0\hadoop-hdfs-2.2.0.jar;C:\Users\cq\.m2\repository\xmlenc\xmlenc\0.52\xmlenc-0.52.jar;C:\Users\cq\.m2\repository\jline\jline\2.12\jline-2.12.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-http\9.3.20.v20170531\jetty-http-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-rewrite\9.3.20.v20170531\jetty-rewrite-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-client\9.3.20.v20170531\jetty-client-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\joda-time\joda-time\2.9.9\joda-time-2.9.9.jar;C:\Users\cq\.m2\repository\org\apache\logging\log4j\log4j-1.2-api\2.10.0\log4j-1.2-api-2.10.0.jar;C:\Users\cq\.m2\repository\org\apache\logging\log4j\log4j-api\2.10.0\log4j-api-2.10.0.jar;C:\Users\cq\.m2\repository\org\apache\logging\log4j\log4j-core\2.10.0\log4j-core-2.10.0.jar;C:\Users\cq\.m2\repository\org\apache\logging\log4j\log4j-web\2.10.0\log4j-web-2.10.0.jar;C:\Users\cq\.m2\repository\org\apache\logging\log4j\log4j-slf4j-impl\2.10.0\log4j-slf4j-impl-2.10.0.jar;C:\Users\cq\.m2\repository\org\apache\ant\ant\1.9.1\ant-1.9.1.jar;C:\Users\cq\.m2\repository\org\apache\ant\ant-launcher\1.9.1\ant-launcher-1.9.1.jar;C:\Users\cq\.m2\repository\net\sf\jpam\jpam\1.1\jpam-1.1.jar;C:\Users\cq\.m2\repository\com\tdunning\json\1.8\json-1.8.jar;C:\Users\cq\.m2\repository\io\dropwizard\metrics\metrics-core\3.1.0\metrics-core-3.1.0.jar;C:\Users\cq\.m2\repository\io\dropwizard\metrics\metrics-jvm\3.1.0\metrics-jvm-3.1.0.jar;C:\Users\cq\.m2\repository\io\dropwizard\metrics\metrics-json\3.1.0\metrics-json-3.1.0.jar;C:\Users\cq\.m2\repository\com\github\joshelser\dropwizard-metrics-hadoop-metrics2-reporter\0.1.2\dropwizard-metrics-hadoop-metrics2-reporter-0.1.2.jar;C:\Users\cq\.m2\repository\javolution\javolution\5.5.1\javolution-5.5.1.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-service\3.1.2\hive-service-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-llap-server\3.1.2\hive-llap-server-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-llap-common\3.1.2\hive-llap-common-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-llap-client\3.1.2\hive-llap-client-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-llap-tez\3.1.2\hive-llap-tez-3.1.2.jar;C:\Users\cq\.m2\repository\io\netty\netty-all\4.1.17.Final\netty-all-4.1.17.Final.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-llap-common\3.1.2\hive-llap-common-3.1.2-tests.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-hadoop2-compat\2.0.0-alpha4\hbase-hadoop2-compat-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-metrics\2.0.0-alpha4\hbase-metrics-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-metrics-api\2.0.0-alpha4\hbase-metrics-api-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-mapreduce-client-core\2.7.1\hadoop-mapreduce-client-core-2.7.1.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-server\2.0.0-alpha4\hbase-server-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-http\2.0.0-alpha4\hbase-http-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\glassfish\jersey\core\jersey-server\2.25.1\jersey-server-2.25.1.jar;C:\Users\cq\.m2\repository\org\glassfish\jersey\core\jersey-common\2.25.1\jersey-common-2.25.1.jar;C:\Users\cq\.m2\repository\org\glassfish\jersey\bundles\repackaged\jersey-guava\2.25.1\jersey-guava-2.25.1.jar;C:\Users\cq\.m2\repository\org\glassfish\hk2\osgi-resource-locator\1.0.1\osgi-resource-locator-1.0.1.jar;C:\Users\cq\.m2\repository\org\glassfish\jersey\core\jersey-client\2.25.1\jersey-client-2.25.1.jar;C:\Users\cq\.m2\repository\org\glassfish\jersey\media\jersey-media-jaxb\2.25.1\jersey-media-jaxb-2.25.1.jar;C:\Users\cq\.m2\repository\org\glassfish\hk2\hk2-api\2.5.0-b32\hk2-api-2.5.0-b32.jar;C:\Users\cq\.m2\repository\org\glassfish\hk2\hk2-utils\2.5.0-b32\hk2-utils-2.5.0-b32.jar;C:\Users\cq\.m2\repository\org\glassfish\hk2\external\aopalliance-repackaged\2.5.0-b32\aopalliance-repackaged-2.5.0-b32.jar;C:\Users\cq\.m2\repository\org\glassfish\hk2\external\javax.inject\2.5.0-b32\javax.inject-2.5.0-b32.jar;C:\Users\cq\.m2\repository\org\glassfish\hk2\hk2-locator\2.5.0-b32\hk2-locator-2.5.0-b32.jar;C:\Users\cq\.m2\repository\org\javassist\javassist\3.20.0-GA\javassist-3.20.0-GA.jar;C:\Users\cq\.m2\repository\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;C:\Users\cq\.m2\repository\org\glassfish\jersey\containers\jersey-container-servlet-core\2.25.1\jersey-container-servlet-core-2.25.1.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-procedure\2.0.0-alpha4\hbase-procedure-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-common\2.0.0-alpha4\hbase-common-2.0.0-alpha4-tests.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-replication\2.0.0-alpha4\hbase-replication-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-prefix-tree\2.0.0-alpha4\hbase-prefix-tree-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\apache\commons\commons-collections4\4.1\commons-collections4-4.1.jar;C:\Users\cq\.m2\repository\org\glassfish\web\javax.servlet.jsp\2.3.2\javax.servlet.jsp-2.3.2.jar;C:\Users\cq\.m2\repository\org\glassfish\javax.el\3.0.1-b12\javax.el-3.0.1-b12.jar;C:\Users\cq\.m2\repository\javax\ws\rs\javax.ws.rs-api\2.0.1\javax.ws.rs-api-2.0.1.jar;C:\Users\cq\.m2\repository\com\lmax\disruptor\3.3.6\disruptor-3.3.6.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-distcp\2.7.1\hadoop-distcp-2.7.1.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-client\2.7.1\hadoop-client-2.7.1.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-mapreduce-client-app\2.7.1\hadoop-mapreduce-client-app-2.7.1.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-mapreduce-client-common\2.7.1\hadoop-mapreduce-client-common-2.7.1.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-yarn-client\2.7.1\hadoop-yarn-client-2.7.1.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-mapreduce-client-shuffle\2.7.1\hadoop-mapreduce-client-shuffle-2.7.1.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-mapreduce-client-jobclient\2.7.1\hadoop-mapreduce-client-jobclient-2.7.1.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-mapreduce\2.0.0-alpha4\hbase-mapreduce-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-common\2.0.0-alpha4\hbase-common-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\com\github\stephenc\findbugs\findbugs-annotations\1.3.9-1\findbugs-annotations-1.3.9-1.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-hadoop-compat\2.0.0-alpha4\hbase-hadoop-compat-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\javax\servlet\jsp\javax.servlet.jsp-api\2.3.1\javax.servlet.jsp-api-2.3.1.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-runner\9.3.20.v20170531\jetty-runner-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-plus\9.3.20.v20170531\jetty-plus-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-annotations\9.3.20.v20170531\jetty-annotations-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\javax\annotation\javax.annotation-api\1.2\javax.annotation-api-1.2.jar;C:\Users\cq\.m2\repository\org\ow2\asm\asm\5.0.1\asm-5.0.1.jar;C:\Users\cq\.m2\repository\org\ow2\asm\asm-commons\5.0.1\asm-commons-5.0.1.jar;C:\Users\cq\.m2\repository\org\ow2\asm\asm-tree\5.0.1\asm-tree-5.0.1.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-jaas\9.3.20.v20170531\jetty-jaas-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\websocket\websocket-server\9.3.20.v20170531\websocket-server-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\websocket\websocket-common\9.3.20.v20170531\websocket-common-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\websocket\websocket-api\9.3.20.v20170531\websocket-api-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\websocket\websocket-client\9.3.20.v20170531\websocket-client-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\websocket\websocket-servlet\9.3.20.v20170531\websocket-servlet-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-jndi\9.3.20.v20170531\jetty-jndi-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\apache-jsp\9.3.20.v20170531\apache-jsp-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\toolchain\jetty-schemas\3.1\jetty-schemas-3.1.jar;C:\Users\cq\.m2\repository\org\eclipse\jdt\core\compiler\ecj\4.4.2\ecj-4.4.2.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\apache-jstl\9.3.20.v20170531\apache-jstl-9.3.20.v20170531.jar;C:\Users\cq\.m2\repository\org\apache\taglibs\taglibs-standard-spec\1.2.5\taglibs-standard-spec-1.2.5.jar;C:\Users\cq\.m2\repository\org\apache\taglibs\taglibs-standard-impl\1.2.5\taglibs-standard-impl-1.2.5.jar;C:\Users\cq\.m2\repository\org\apache\thrift\libfb303\0.9.3\libfb303-0.9.3.jar;C:\Users\cq\.m2\repository\org\jamon\jamon-runtime\2.3.1\jamon-runtime-2.3.1.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-serde\3.1.2\hive-serde-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\arrow\arrow-vector\0.8.0\arrow-vector-0.8.0.jar;C:\Users\cq\.m2\repository\org\apache\arrow\arrow-format\0.8.0\arrow-format-0.8.0.jar;C:\Users\cq\.m2\repository\org\apache\arrow\arrow-memory\0.8.0\arrow-memory-0.8.0.jar;C:\Users\cq\.m2\repository\io\netty\netty-buffer\4.1.17.Final\netty-buffer-4.1.17.Final.jar;C:\Users\cq\.m2\repository\io\netty\netty-common\4.1.17.Final\netty-common-4.1.17.Final.jar;C:\Users\cq\.m2\repository\com\carrotsearch\hppc\0.7.2\hppc-0.7.2.jar;C:\Users\cq\.m2\repository\com\vlkan\flatbuffers\1.2.0-3f79e055\flatbuffers-1.2.0-3f79e055.jar;C:\Users\cq\.m2\repository\net\sf\opencsv\opencsv\2.3\opencsv-2.3.jar;C:\Users\cq\.m2\repository\org\apache\parquet\parquet-hadoop-bundle\1.10.0\parquet-hadoop-bundle-1.10.0.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-metastore\3.1.2\hive-metastore-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-standalone-metastore\3.1.2\hive-standalone-metastore-3.1.2.jar;C:\Users\cq\.m2\repository\org\datanucleus\datanucleus-api-jdo\4.2.4\datanucleus-api-jdo-4.2.4.jar;C:\Users\cq\.m2\repository\org\datanucleus\datanucleus-core\4.1.17\datanucleus-core-4.1.17.jar;C:\Users\cq\.m2\repository\org\datanucleus\datanucleus-rdbms\4.1.19\datanucleus-rdbms-4.1.19.jar;C:\Users\cq\.m2\repository\org\datanucleus\javax.jdo\3.2.0-m3\javax.jdo-3.2.0-m3.jar;C:\Users\cq\.m2\repository\javax\transaction\transaction-api\1.1\transaction-api-1.1.jar;C:\Users\cq\.m2\repository\sqlline\sqlline\1.3.0\sqlline-1.3.0.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-client\2.0.0-alpha4\hbase-client-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\apache\hbase\thirdparty\hbase-shaded-protobuf\1.0.1\hbase-shaded-protobuf-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-protocol-shaded\2.0.0-alpha4\hbase-protocol-shaded-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\apache\hbase\hbase-protocol\2.0.0-alpha4\hbase-protocol-2.0.0-alpha4.jar;C:\Users\cq\.m2\repository\org\apache\hbase\thirdparty\hbase-shaded-miscellaneous\1.0.1\hbase-shaded-miscellaneous-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\hbase\thirdparty\hbase-shaded-netty\1.0.1\hbase-shaded-netty-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\htrace\htrace-core\3.2.0-incubating\htrace-core-3.2.0-incubating.jar;C:\Users\cq\.m2\repository\org\jruby\jcodings\jcodings\1.0.18\jcodings-1.0.18.jar;C:\Users\cq\.m2\repository\org\jruby\joni\joni\2.1.11\joni-2.1.11.jar;C:\Users\cq\.m2\repository\org\apache\commons\commons-crypto\1.0.0\commons-crypto-1.0.0.jar;C:\Users\cq\.m2\repository\org\apache\yetus\audience-annotations\0.5.0\audience-annotations-0.5.0.jar;C:\Users\cq\.m2\repository\com\jolbox\bonecp\0.8.0.RELEASE\bonecp-0.8.0.RELEASE.jar;C:\Users\cq\.m2\repository\com\zaxxer\HikariCP\2.6.1\HikariCP-2.6.1.jar;C:\Users\cq\.m2\repository\org\apache\derby\derby\10.14.1.0\derby-10.14.1.0.jar;C:\Users\cq\.m2\repository\commons-pool\commons-pool\1.5.4\commons-pool-1.5.4.jar;C:\Users\cq\.m2\repository\commons-dbcp\commons-dbcp\1.4\commons-dbcp-1.4.jar;C:\Users\cq\.m2\repository\javax\jdo\jdo-api\3.0.1\jdo-api-3.0.1.jar;C:\Users\cq\.m2\repository\javax\transaction\jta\1.1\jta-1.1.jar;C:\Users\cq\.m2\repository\org\antlr\antlr-runtime\3.5.2\antlr-runtime-3.5.2.jar;C:\Users\cq\.m2\repository\co\cask\tephra\tephra-api\0.6.0\tephra-api-0.6.0.jar;C:\Users\cq\.m2\repository\co\cask\tephra\tephra-core\0.6.0\tephra-core-0.6.0.jar;C:\Users\cq\.m2\repository\com\google\inject\guice\3.0\guice-3.0.jar;C:\Users\cq\.m2\repository\javax\inject\javax.inject\1\javax.inject-1.jar;C:\Users\cq\.m2\repository\aopalliance\aopalliance\1.0\aopalliance-1.0.jar;C:\Users\cq\.m2\repository\com\google\inject\extensions\guice-assistedinject\3.0\guice-assistedinject-3.0.jar;C:\Users\cq\.m2\repository\it\unimi\dsi\fastutil\6.5.6\fastutil-6.5.6.jar;C:\Users\cq\.m2\repository\org\apache\twill\twill-common\0.6.0-incubating\twill-common-0.6.0-incubating.jar;C:\Users\cq\.m2\repository\org\apache\twill\twill-core\0.6.0-incubating\twill-core-0.6.0-incubating.jar;C:\Users\cq\.m2\repository\org\apache\twill\twill-api\0.6.0-incubating\twill-api-0.6.0-incubating.jar;C:\Users\cq\.m2\repository\org\apache\twill\twill-discovery-api\0.6.0-incubating\twill-discovery-api-0.6.0-incubating.jar;C:\Users\cq\.m2\repository\org\apache\twill\twill-discovery-core\0.6.0-incubating\twill-discovery-core-0.6.0-incubating.jar;C:\Users\cq\.m2\repository\org\apache\twill\twill-zookeeper\0.6.0-incubating\twill-zookeeper-0.6.0-incubating.jar;C:\Users\cq\.m2\repository\co\cask\tephra\tephra-hbase-compat-1.0\0.6.0\tephra-hbase-compat-1.0-0.6.0.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-shims\3.1.2\hive-shims-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hive\shims\hive-shims-common\3.1.2\hive-shims-common-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hive\shims\hive-shims-0.23\3.1.2\hive-shims-0.23-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-yarn-server-resourcemanager\3.1.0\hadoop-yarn-server-resourcemanager-3.1.0.jar;C:\Users\cq\.m2\repository\com\google\inject\extensions\guice-servlet\4.0\guice-servlet-4.0.jar;C:\Users\cq\.m2\repository\com\sun\jersey\contribs\jersey-guice\1.19\jersey-guice-1.19.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-yarn-common\3.1.0\hadoop-yarn-common-3.1.0.jar;C:\Users\cq\.m2\repository\com\fasterxml\jackson\module\jackson-module-jaxb-annotations\2.7.8\jackson-module-jaxb-annotations-2.7.8.jar;C:\Users\cq\.m2\repository\com\fasterxml\jackson\jaxrs\jackson-jaxrs-json-provider\2.7.8\jackson-jaxrs-json-provider-2.7.8.jar;C:\Users\cq\.m2\repository\com\fasterxml\jackson\jaxrs\jackson-jaxrs-base\2.7.8\jackson-jaxrs-base-2.7.8.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-yarn-api\3.1.0\hadoop-yarn-api-3.1.0.jar;C:\Users\cq\.m2\repository\com\sun\jersey\jersey-client\1.19\jersey-client-1.19.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-util-ajax\9.3.19.v20170502\jetty-util-ajax-9.3.19.v20170502.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-yarn-server-common\3.1.0\hadoop-yarn-server-common-3.1.0.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-yarn-registry\3.1.0\hadoop-yarn-registry-3.1.0.jar;C:\Users\cq\.m2\repository\commons-daemon\commons-daemon\1.0.13\commons-daemon-1.0.13.jar;C:\Users\cq\.m2\repository\org\apache\geronimo\specs\geronimo-jcache_1.0_spec\1.0-alpha-1\geronimo-jcache_1.0_spec-1.0-alpha-1.jar;C:\Users\cq\.m2\repository\org\ehcache\ehcache\3.3.1\ehcache-3.3.1.jar;C:\Users\cq\.m2\repository\com\zaxxer\HikariCP-java7\2.4.12\HikariCP-java7-2.4.12.jar;C:\Users\cq\.m2\repository\com\microsoft\sqlserver\mssql-jdbc\6.2.1.jre7\mssql-jdbc-6.2.1.jre7.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-yarn-server-applicationhistoryservice\3.1.0\hadoop-yarn-server-applicationhistoryservice-3.1.0.jar;C:\Users\cq\.m2\repository\de\ruedigermoeller\fst\2.50\fst-2.50.jar;C:\Users\cq\.m2\repository\com\cedarsoftware\java-util\1.9.0\java-util-1.9.0.jar;C:\Users\cq\.m2\repository\com\cedarsoftware\json-io\2.5.1\json-io-2.5.1.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-yarn-server-web-proxy\3.1.0\hadoop-yarn-server-web-proxy-3.1.0.jar;C:\Users\cq\.m2\repository\org\fusesource\leveldbjni\leveldbjni-all\1.8\leveldbjni-all-1.8.jar;C:\Users\cq\.m2\repository\org\apache\hive\shims\hive-shims-scheduler\3.1.2\hive-shims-scheduler-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-service-rpc\3.1.2\hive-service-rpc-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\httpcomponents\httpclient\4.5.2\httpclient-4.5.2.jar;C:\Users\cq\.m2\repository\org\apache\httpcomponents\httpcore\4.4.4\httpcore-4.4.4.jar;C:\Users\cq\.m2\repository\org\apache\thrift\libthrift\0.9.3\libthrift-0.9.3.jar;C:\Users\cq\.m2\repository\org\apache\zookeeper\zookeeper\3.4.6\zookeeper-3.4.6.jar;C:\Users\cq\.m2\repository\io\netty\netty\3.7.0.Final\netty-3.7.0.Final.jar;C:\Users\cq\.m2\repository\org\apache\curator\curator-framework\2.12.0\curator-framework-2.12.0.jar;C:\Users\cq\.m2\repository\org\slf4j\slf4j-api\1.7.10\slf4j-api-1.7.10.jar;C:\Users\cq\.m2\repository\org\apache\hive\hive-upgrade-acid\3.1.2\hive-upgrade-acid-3.1.2.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-common\3.3.0\hadoop-common-3.3.0.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\thirdparty\hadoop-shaded-protobuf_3_7\1.0.0\hadoop-shaded-protobuf_3_7-1.0.0.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-annotations\3.3.0\hadoop-annotations-3.3.0.jar;C:\Users\cq\.m2\repository\com\google\guava\guava\27.0-jre\guava-27.0-jre.jar;C:\Users\cq\.m2\repository\com\google\guava\failureaccess\1.0\failureaccess-1.0.jar;C:\Users\cq\.m2\repository\com\google\guava\listenablefuture\9999.0-empty-to-avoid-conflict-with-guava\listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar;C:\Users\cq\.m2\repository\org\checkerframework\checker-qual\2.5.2\checker-qual-2.5.2.jar;C:\Users\cq\.m2\repository\com\google\j2objc\j2objc-annotations\1.1\j2objc-annotations-1.1.jar;C:\Users\cq\.m2\repository\org\codehaus\mojo\animal-sniffer-annotations\1.17\animal-sniffer-annotations-1.17.jar;C:\Users\cq\.m2\repository\commons-cli\commons-cli\1.2\commons-cli-1.2.jar;C:\Users\cq\.m2\repository\org\apache\commons\commons-math3\3.1.1\commons-math3-3.1.1.jar;C:\Users\cq\.m2\repository\commons-codec\commons-codec\1.11\commons-codec-1.11.jar;C:\Users\cq\.m2\repository\commons-io\commons-io\2.5\commons-io-2.5.jar;C:\Users\cq\.m2\repository\commons-net\commons-net\3.6\commons-net-3.6.jar;C:\Users\cq\.m2\repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;C:\Users\cq\.m2\repository\javax\servlet\javax.servlet-api\3.1.0\javax.servlet-api-3.1.0.jar;C:\Users\cq\.m2\repository\javax\activation\javax.activation-api\1.2.0\javax.activation-api-1.2.0.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-server\9.4.20.v20190813\jetty-server-9.4.20.v20190813.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-io\9.4.20.v20190813\jetty-io-9.4.20.v20190813.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-util\9.4.20.v20190813\jetty-util-9.4.20.v20190813.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-servlet\9.4.20.v20190813\jetty-servlet-9.4.20.v20190813.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-security\9.4.20.v20190813\jetty-security-9.4.20.v20190813.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-webapp\9.4.20.v20190813\jetty-webapp-9.4.20.v20190813.jar;C:\Users\cq\.m2\repository\org\eclipse\jetty\jetty-xml\9.4.20.v20190813\jetty-xml-9.4.20.v20190813.jar;C:\Users\cq\.m2\repository\javax\servlet\jsp\jsp-api\2.1\jsp-api-2.1.jar;C:\Users\cq\.m2\repository\com\sun\jersey\jersey-core\1.19\jersey-core-1.19.jar;C:\Users\cq\.m2\repository\javax\ws\rs\jsr311-api\1.1.1\jsr311-api-1.1.1.jar;C:\Users\cq\.m2\repository\com\sun\jersey\jersey-servlet\1.19\jersey-servlet-1.19.jar;C:\Users\cq\.m2\repository\com\sun\jersey\jersey-json\1.19\jersey-json-1.19.jar;C:\Users\cq\.m2\repository\org\codehaus\jettison\jettison\1.1\jettison-1.1.jar;C:\Users\cq\.m2\repository\com\sun\xml\bind\jaxb-impl\2.2.3-1\jaxb-impl-2.2.3-1.jar;C:\Users\cq\.m2\repository\org\codehaus\jackson\jackson-core-asl\1.9.2\jackson-core-asl-1.9.2.jar;C:\Users\cq\.m2\repository\org\codehaus\jackson\jackson-mapper-asl\1.9.2\jackson-mapper-asl-1.9.2.jar;C:\Users\cq\.m2\repository\org\codehaus\jackson\jackson-jaxrs\1.9.2\jackson-jaxrs-1.9.2.jar;C:\Users\cq\.m2\repository\org\codehaus\jackson\jackson-xc\1.9.2\jackson-xc-1.9.2.jar;C:\Users\cq\.m2\repository\com\sun\jersey\jersey-server\1.19\jersey-server-1.19.jar;C:\Users\cq\.m2\repository\commons-logging\commons-logging\1.1.3\commons-logging-1.1.3.jar;C:\Users\cq\.m2\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;C:\Users\cq\.m2\repository\commons-beanutils\commons-beanutils\1.9.4\commons-beanutils-1.9.4.jar;C:\Users\cq\.m2\repository\org\apache\commons\commons-configuration2\2.1.1\commons-configuration2-2.1.1.jar;C:\Users\cq\.m2\repository\org\apache\commons\commons-lang3\3.7\commons-lang3-3.7.jar;C:\Users\cq\.m2\repository\org\apache\commons\commons-text\1.4\commons-text-1.4.jar;C:\Users\cq\.m2\repository\org\slf4j\slf4j-log4j12\1.7.25\slf4j-log4j12-1.7.25.jar;C:\Users\cq\.m2\repository\org\apache\avro\avro\1.7.7\avro-1.7.7.jar;C:\Users\cq\.m2\repository\com\thoughtworks\paranamer\paranamer\2.3\paranamer-2.3.jar;C:\Users\cq\.m2\repository\org\xerial\snappy\snappy-java\1.0.5\snappy-java-1.0.5.jar;C:\Users\cq\.m2\repository\com\google\re2j\re2j\1.1\re2j-1.1.jar;C:\Users\cq\.m2\repository\com\google\protobuf\protobuf-java\2.5.0\protobuf-java-2.5.0.jar;C:\Users\cq\.m2\repository\com\google\code\gson\gson\2.2.4\gson-2.2.4.jar;C:\Users\cq\.m2\repository\org\apache\hadoop\hadoop-auth\3.3.0\hadoop-auth-3.3.0.jar;C:\Users\cq\.m2\repository\com\nimbusds\nimbus-jose-jwt\7.9\nimbus-jose-jwt-7.9.jar;C:\Users\cq\.m2\repository\com\github\stephenc\jcip\jcip-annotations\1.0-1\jcip-annotations-1.0-1.jar;C:\Users\cq\.m2\repository\net\minidev\json-smart\2.3\json-smart-2.3.jar;C:\Users\cq\.m2\repository\net\minidev\accessors-smart\1.2\accessors-smart-1.2.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerb-simplekdc\1.0.1\kerb-simplekdc-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerb-client\1.0.1\kerb-client-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerby-config\1.0.1\kerby-config-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerb-common\1.0.1\kerb-common-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerb-crypto\1.0.1\kerb-crypto-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerb-util\1.0.1\kerb-util-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\token-provider\1.0.1\token-provider-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerb-admin\1.0.1\kerb-admin-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerb-server\1.0.1\kerb-server-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerb-identity\1.0.1\kerb-identity-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerby-xdr\1.0.1\kerby-xdr-1.0.1.jar;C:\Users\cq\.m2\repository\com\jcraft\jsch\0.1.55\jsch-0.1.55.jar;C:\Users\cq\.m2\repository\org\apache\curator\curator-client\4.2.0\curator-client-4.2.0.jar;C:\Users\cq\.m2\repository\org\apache\curator\curator-recipes\4.2.0\curator-recipes-4.2.0.jar;C:\Users\cq\.m2\repository\com\google\code\findbugs\jsr305\3.0.2\jsr305-3.0.2.jar;C:\Users\cq\.m2\repository\org\apache\htrace\htrace-core4\4.1.0-incubating\htrace-core4-4.1.0-incubating.jar;C:\Users\cq\.m2\repository\org\apache\commons\commons-compress\1.19\commons-compress-1.19.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerb-core\1.0.1\kerb-core-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerby-pkix\1.0.1\kerby-pkix-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerby-asn1\1.0.1\kerby-asn1-1.0.1.jar;C:\Users\cq\.m2\repository\org\apache\kerby\kerby-util\1.0.1\kerby-util-1.0.1.jar;C:\Users\cq\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.10.3\jackson-databind-2.10.3.jar;C:\Users\cq\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.10.3\jackson-annotations-2.10.3.jar;C:\Users\cq\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.10.3\jackson-core-2.10.3.jar;C:\Users\cq\.m2\repository\org\codehaus\woodstox\stax2-api\3.1.4\stax2-api-3.1.4.jar;C:\Users\cq\.m2\repository\com\fasterxml\woodstox\woodstox-core\5.0.3\woodstox-core-5.0.3.jar;C:\Users\cq\.m2\repository\dnsjava\dnsjava\2.1.7\dnsjava-2.1.7.jar" gov.czt.HiveClient
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/C:/Users/cq/.m2/repository/org/apache/logging/log4j/log4j-slf4j-impl/2.10.0/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/C:/Users/cq/.m2/repository/org/slf4j/slf4j-log4j12/1.7.25/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system property 'log4j2.debug' to show Log4j2 internal initialization logging.
Running: describe hive1_mid
year string
month string
day string
temperature smallint
Running: select * from hive1_mid
1949 10 01 38
1949 10 02 36
1950 01 01 32
1950 10 01 37
1950 10 02 41
1950 10 03 27
1951 07 01 45
1951 07 02 46
1951 07 03 47
1951 12 01 23
Running: select count(1) from hive1_mid
10

Process finished with exit code 0

Hive的介绍到此结束,如果想了解更详细的内容,建议看hive官网APACHE HIVE TM,非常详细,比市面上的书籍更新快且权威,缺点是知识点太零散,不好找。