📖 HBase와 Hive 연동하기
HBase Emp 테이블 생성 후 데이터 삽입
hbase:001:0> create 'emp','personal'
hbase:002:0> put 'emp',1,'personal:name','pojo'
HBase에 접근하기 위해 ZooKeeper주소를 커맨드라인으로 실행할때 인자로 넣어주기!👍
다른방법으로는 hive-site.xml에 다음 아래와 같이 추가
<property>
<name>hbase.zookeeper.quorum</name>
<value> pipeline-zookeeper-a,pipeline-zookeeper-b,pipeline-zookeeper-c </value>
</property>
hive --auxpath $HIVE_HOME/lib/hive-hbase-handler-3.1.2.jar --hiveconf hbase.zookeeper.quorum=pipeline-zookeeper-a,pipeline-zookeeper-b,pipeline-zookeeper-c
CREATE EXTERNAL TABLE hbase_table_emp(id int, name string) \
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' \
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,personal:name") \
TBLPROPERTIES ("hbase.table.name" = "emp");
hive> select * from hbase_table_emp;
OK
1 pojo