I want to access hbase using hive 2.1.1 ,I use the command:
hive -hiveconf hive.root.logger=DEBUG,console hbase.master=node131:16000
Then I try to create table:
CREATE TABLE iteblog(key int, value string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" =":key,cf1:val") TBLPROPERTIES ("hbase.table.name" = "iteblog", "hbase.mapred.output.outputtable" = "iteblog");
I found log: INFO [main] zookeeper.RecoverableZooKeeper: Process identifier=hconnection-0x7cf63b9a connecting to ZooKeeper ensemble=192.168.156.24:2181 . but I don't config 192.168.156.24 in hive or hadoop, I don't know why it show up .where can I find this config or change it? I install hive in 192.168.156.25 and node131 is where hbase was installed.
/etc/hbase/conf/hbase-site.xml? You should find interesting stuff in there, especiallyhbase.zookeeper.quorum(which gets defaulted to your local host name + port 2181 by the HBase client, when not present) - Samson Scharfrichterhbase.masterprop is pretty useless nowadays, because HBase client will contact ZK to get the active Master automatically (in case you have 2 in active/passive HA). - Samson Scharfrichter