hive-hbase整合报错：Error: java.lang.UnsupportedClassVersionError: org/apache/hadoop/hive/hbase/HBaseStor

1.整合报错

 
  
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> CREATE TABLE
  hive_hbase_emp_table(
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> empno int,
  0: jdbc:hive2://hadoop210.cevent.com:10000>
  ename string,
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> job string,
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> mgr int,
  0: jdbc:hive2://hadoop210.cevent.com:10000>
  hiredate string,
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> sal double,
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> comm double,
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> deptno int)
  0: jdbc:hive2://hadoop210.cevent.com:10000>
  STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
  0: jdbc:hive2://hadoop210.cevent.com:10000>
  WITH SERDEPROPERTIES ("hbase.columns.mapping" =
  ":key,info:ename,info:job,info:mgr,info:hiredate,info:sal,info:comm,info:deptno")
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> TBLPROPERTIES
  ("hbase.table.name" = "hbase_emp_table");
  Error: java.lang.UnsupportedClassVersionError:
  org/apache/hadoop/hive/hbase/HBaseStorageHandler : Unsupported major.minor
  version 52.0 (state=,code=0)
  
 

2.官网下载源码

链接：http://archive.apache.org/dist/hive/hive-1.2.1/

3.eclipse创建java工程

4.主目录下创建lib文件夹

5.导入包

6.引入jar包

7.删除jar

8.注意包名

9.导出jar

10.hive-hbase-handler-1.2.1.jar

11.重新启动

 
  
  [cevent@hadoop210 hadoop-2.7.2]$ sbin/start-dfs.sh
  [cevent@hadoop210 hadoop-2.7.2]$ sbin/start-yarn.sh 
  [cevent@hadoop210 hadoop-2.7.2]$ zkServer.sh start
  [cevent@hadoop210 hadoop-2.7.2]$ jps
  4370 ResourceManager
  4488 NodeManager
  4841 QuorumPeerMain
  4965 Jps
  3448 NameNode
  3745 SecondaryNameNode
  3565 DataNode
   
  [cevent@hadoop210 hbase-1.3.1]$ bin/start-hbase.sh 
  starting master, logging to
  /opt/module/hbase-1.3.1/logs/hbase-cevent-master-hadoop210.cevent.com.out
  hadoop212.cevent.com: starting
  regionserver, logging to /opt/module/hbase-1.3.1/bin/../logs/hbase-cevent-regionserver-hadoop212.cevent.com.out
  hadoop211.cevent.com: starting
  regionserver, logging to
  /opt/module/hbase-1.3.1/bin/../logs/hbase-cevent-regionserver-hadoop211.cevent.com.out
  hadoop210.cevent.com: starting regionserver,
  logging to
  /opt/module/hbase-1.3.1/bin/../logs/hbase-cevent-regionserver-hadoop210.cevent.com.out
  [cevent@hadoop210 hbase-1.3.1]$ jps
  4370 ResourceManager
  5115 HMaster
  4488 NodeManager
  4841 QuorumPeerMain
  3448 NameNode
  3745 SecondaryNameNode
  3565 DataNode
  5393 Jps
  5262 HRegionServer
   
  
 

12.动hiveserver2和beeline插入数据

 
  
  [cevent@hadoop210 hive-1.2.1]$ ll
  总用量 532
  drwxrwxr-x. 3 cevent cevent   4096 6月  28 16:23 bin
  drwxrwxr-x. 2 cevent cevent   4096 6月  28 21:08 conf
  -rw-rw-r--. 1 cevent cevent  21061 6月  28 16:35 derby.log
  drwxrwxr-x. 4 cevent cevent   4096 6月  28 16:23 examples
  drwxrwxr-x. 7 cevent cevent   4096 6月  28 16:23 hcatalog
  drwxrwxr-x. 4 cevent cevent   4096 6月  29 09:24 lib
  -rw-rw-r--. 1 cevent cevent  24754 4月  30 2015 LICENSE
  drwxrwxr-x. 5 cevent cevent   4096 6月  28 16:35 metastore_db
  -rw-rw-r--. 1 cevent cevent    397 6月  19 2015 NOTICE
  -rw-rw-r--. 1 cevent cevent   4366 6月  19 2015 README.txt
  -rw-rw-r--. 1 cevent cevent 421129 6月  19 2015 RELEASE_NOTES.txt
  drwxrwxr-x. 3 cevent cevent   4096 6月  28 16:23 scripts
  -rw-rw-r--. 1 cevent cevent  24896 6月  28 22:32 zookeeper.out
  [cevent@hadoop210 hive-1.2.1]$ bin/hiveserver2 
   
  [cevent@hadoop210 hive-1.2.1]$ bin/beeline 
  Beeline version 1.2.1 by Apache Hive
   
  beeline> !connect
  jdbc:hive2://hadoop210.cevent.com:10000
  Connecting to
  jdbc:hive2://hadoop210.cevent.com:10000
  Enter username for
  jdbc:hive2://hadoop210.cevent.com:10000: cevent
  Enter password for
  jdbc:hive2://hadoop210.cevent.com:10000: ******
  Connected to: Apache Hive (version 1.2.1)
  Driver: Hive JDBC (version 1.2.1)
  Transaction isolation:
  TRANSACTION_REPEATABLE_READ
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> show tables;
  +-----------+--+
  | tab_name  |
  +-----------+--+
  | student   |
  +-----------+--+
  1 row selected (1.458 seconds)  创建hive表和hbase表
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> CREATE
  TABLE hive_hbase_emp_table(
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> empno
  int,
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> ename
  string,
  0: jdbc:hive2://hadoop210.cevent.com:10000>
  job string,
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> mgr int,
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> hiredate
  string,
  0: jdbc:hive2://hadoop210.cevent.com:10000> sal double,
  0: jdbc:hive2://hadoop210.cevent.com:10000>
  comm double,
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> deptno
  int)
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> STORED
  BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
  0: jdbc:hive2://hadoop210.cevent.com:10000>
  
  WITH
  SERDEPROPERTIES 
  ("hbase.columns.mapping"
  =
  ":key,info:ename,info:job,info:mgr,info:hiredate,info:sal,info:comm,info:deptno")
  0:
  jdbc:hive2://hadoop210.cevent.com:10000> TBLPROPERTIES
  ("hbase.table.name" = "hbase_emp_table");
  No rows affected (5.286 seconds)
  0: jdbc:hive2://hadoop210.cevent.com:10000>
  show tables;
  +-----------------------+--+
  |      
  tab_name        |
  +-----------------------+--+
  | hive_hbase_emp_table  |
  | student               |
  +-----------------------+--+
  2 rows selected (0.057 seconds)
  0: jdbc:hive2://hadoop210.cevent.com:10000>
  插入数据
  insert into table
  hive_hbase_emp_table values(2020,'cevent','developer',201,'2020-06-29',20000,2000,619);
  INFO 
  : Number of reduce tasks is set to 0 since there's no reduce operator
  INFO 
  : number of splits:1
  INFO 
  : Submitting tokens for job: job_1593393499225_0001
  INFO 
  : The url to track the job:
  http://hadoop210.cevent.com:8088/proxy/application_1593393499225_0001/
  INFO 
  : Starting Job = job_1593393499225_0001, Tracking URL =
  http://hadoop210.cevent.com:8088/proxy/application_1593393499225_0001/
  INFO 
  : Kill Command = /opt/module/hadoop-2.7.2/bin/hadoop job  -kill job_1593393499225_0001
  INFO 
  : Hadoop job information for Stage-0: number of mappers: 1; number of
  reducers: 0
  INFO 
  : 2020-06-29 09:33:36,570 Stage-0 map = 0%,  reduce = 0%
  INFO 
  : 2020-06-29 09:33:44,934 Stage-0 map = 100%,  reduce = 0%, Cumulative CPU 2.79 sec
  INFO 
  : MapReduce Total cumulative CPU time: 2 seconds 790 msec
  INFO 
  : Ended Job = job_1593393499225_0001
  No rows affected (37.702 seconds)
  0: jdbc:hive2://hadoop210.cevent.com:10000>
  select * from hive_hbase_emp_table; 查看hbase中清除数据
  +-----------------------------+-----------------------------+---------------------------+---------------------------+--------------------------------+---------------------------+----------------------------+------------------------------+--+
  | hive_hbase_emp_table.empno  |
  hive_hbase_emp_table.ename  |
  hive_hbase_emp_table.job  |
  hive_hbase_emp_table.mgr  |
  hive_hbase_emp_table.hiredate  |
  hive_hbase_emp_table.sal  |
  hive_hbase_emp_table.comm  |
  hive_hbase_emp_table.deptno  |
  +-----------------------------+-----------------------------+---------------------------+---------------------------+--------------------------------+---------------------------+----------------------------+------------------------------+--+
  +-----------------------------+-----------------------------+---------------------------+---------------------------+--------------------------------+---------------------------+----------------------------+------------------------------+--+
  No rows selected (1.009 seconds)
   
  
 

13.Hbase查看并清除数据

 
  
  [cevent@hadoop210 hbase-1.3.1]$ hbase shell
  SLF4J: Class path contains multiple SLF4J
  bindings.
  SLF4J: Found binding in [jar:file:/opt/module/hbase-1.3.1/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  SLF4J: Found binding in
  [jar:file:/opt/module/hadoop-2.7.2/share/hadoop/common/lib/slf4j-log4j12-1.7.10.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.slf4j.impl.Log4jLoggerFactory]
  HBase Shell; enter 'help<RETURN>'
  for list of supported commands.
  Type "exit<RETURN>" to
  leave the HBase Shell
  Version 1.3.1,
  r930b9a55528fe45d8edce7af42fef2d35e77677a, Thu Apr  6 19:36:54 PDT 2017
   
  hbase(main):001:0> list
  TABLE                                                                                    
  
  hbase_emp_table                                                                           
  student                                                                                   
  2 row(s) in 0.2990 seconds
   
  => ["hbase_emp_table",
  "student"]
  hbase(main):002:0>  scan
  'hbase_emp_table'
  ROW                     COLUMN+CELL                                                      
  
  0 row(s) in 0.2450 seconds
   
  ROW                     COLUMN+CELL                                                      
  
  0 row(s) in 0.0070 seconds
   
  hbase(main):004:0> scan 'hbase_emp_table'
  ROW                     COLUMN+CELL                                                       
   2020                   column=info:comm,
  timestamp=1593394424573, value=2000.0           
   2020                   column=info:deptno,
  timestamp=1593394424573, value=619           
  
   2020                   column=info:ename,
  timestamp=1593394424573, value=cevent         
  
   2020                   column=info:hiredate,
  timestamp=1593394424573, value=2020-06-29  
  
   2020                   column=info:job,
  timestamp=1593394424573, value=developer         
   2020                   column=info:mgr,
  timestamp=1593394424573, value=201               
   2020                   column=info:sal,
  timestamp=1593394424573, value=20000.0   
         
  1 row(s) in 0.0540 seconds
   
  hbase(main):005:0> truncate 'hbase_emp_table' 
  清洗数据
  Truncating 'hbase_emp_table' table (it
  may take a while):
   -
  Disabling table...
   -
  Truncating table...
  0 row(s) in 7.7160 seconds