如何把hive中的数据导入habase详解教程

1. 复制依赖包
   把hbase/lib下的包复制到hive/lib下

cp /usr/local/hbase219/lib/hbase-server-2.1.9.jar ./
cp /usr/local/hbase219/lib/hbase-client-2.1.9.jar  ./
cp /usr/local/hbase219/lib/hbase-protocol-2.1.9.jar  ./
cp /usr/local/hbase219/lib/hbase-it-2.1.9.jar  ./
cp /usr/local/hbase219/lib/hbase-hadoop2-compat-2.1.9.jar  ./

2. 修改hive-site.xml

<property>
	<name>hive.zookeeper.quorum</name>
	<value>node1,node2,node3</value>
 </property> 
 <property>
	<name>hive.zookeeper.client.port</name>
	<value>2181</value>
</property>

3. 测试
   启动hive

    CREATE TABLE hive_hbase_emp_table( 
	empno int,
	ename string, 
	job string,
	mgr int, 
	hiredate string, 
	sal double, 
	comm double, deptno int)
	STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
	WITH SERDEPROPERTIES 
	("hbase.columns.mapping" = ":key,info:ename,info:job,info:mgr,info:hiredate,info:sal,info:comm,info:deptno") 
	TBLPROPERTIES ("hbase.table.name" = "hbase_emp_table");