Hbase1.1.2和和Hive1.2.1可以集成吗?

0
如题,Hbase1.1.2和和Hive1.2.1可以集成吗? 如果可以,怎么集成呢 ,求教程,谢谢了
已邀请:
0

Bob - 同程旅游大数据+BI 架构师 2015-11-18 回答

示例hive sql:CREATE TABLE hbasetable(key int, value int) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val")TBLPROPERTIES ("hbase.table.name" = "hive2hbase");

--使用
INSERT OVERWRITE TABLE hbasetable select * from testkey;

Hive 的hive-site.xml中新增:

  <property>
    <name>hive.aux.jars.path</name> 
 <value>file:///data/hive-0.10.0/lib/hive-hbase-handler-0.10.0.jar,file:///data/hive-0.10.0/lib/hbase-0.90.6-cdh3u5.jar,file:///data/hive-0.10.0/lib/zookeeper-3.3.5-cdh3u5.jar</value>
  </property>
  <property>
    <name>hbase.zookeeper.quorum</name>
    <value>zkhostname01,zkhostname02,zkhostname03</value>
    <description>The directory shared by region servers.
    </description>
  </property>
  
<property>
    <name>hbase.master</name>
    <value>hbasehostname:60000</value>
</property>

要回复问题请先登录注册