2014年9月30日 星期二

Base Table Management Web UI : HareDB client (on HBase)

 Introduction
[Reference]
  http://www.haredb.com/haredb/file/tutorial/HBaseClient_Web_Version_Manual1.94.03.pdf
  http://www.haredb.com/HareDB/src_ap/Product_HareDBClient_Install.aspx?l=4

[HareDB Client Features]
        - Visualized client tool for HBase  >> Better than the command mode
- Easily retrieve data from and put data into HBase
- Can transfer data from RDB to HBase (Using "Data Model Management" func in HBase Client)
- Design your HBase schema only through some configuring in some GUI pages

Install and Start up
[Download]
- http://sourceforge.net/projects/haredbhbaseclie/files/
- Version: HareDBClient_1.98.01s

[Startup]
1. Must setup hostnames of Hbase systems in /etc/hosts
  (Otherwise, it will case the error " unknown hostname")
ex:  $gedit /etc/hosts
  ...
192.168.0.7 master         -------> HBase master/slaver
192.168.0.23 regionserver2  -------> HBase slaver
...
2. Execute the sh file
$sh Download/HareDBClient_1.98.01s/ startup.sh
          Then a HareDB UI web page will appear:
http://localhost:8080/HareDBClient/index.html

3. Setting new Connection to HBase:
1. Click the upper left button on the web page
> "Manage Connections"
> Right Click "Allen"(Default Connection)
> "Clone" and input new name such as "HBase"
> Click "HBase" connection manager
2. Setting Conneciton Infomations:

Connection Name: HBase
ZooKeeper Host/ip: 192.168.0.7 (-> $HBASE_HOME/conf/hbase-site.xml)
ZooKeeper Client Port: 2222   (-> $HBASE_HOME/conf/hbase-site.xml)
fs.default.name: hdfs://192.168.0.7:9000 (-> $HADOOP_HOME/etc/hadoop/core-site.xml)
yarn.resourcemanager.address: 192.168.0.7:8032 (Default)
yarn.resourcemanager.scheduler.address: 192.168.0.7:8030 (Default)
yarn.resourcemanager.resource-tracker.address: 192.168.0.7:8031 (Default)
yarn.resourcemanager.admin.address: 192.168.0.7:8033 (Default)
mapreduce.jobhistory.address: 192.168.0.7:10020 (Default)
coprocessor folder: hdfs://192.168.0.7:9000/tmp (Default)

Hive metastore: "Embedded"

> Click "Apply"

4. Connect to the HBase
> click upper left button on the main page
> Select "HBase" connection which we just created
> the Left area will show Tables of HBase that we connect

[Important Note]
- All table in HBase must register a coprocessor before operating at First Time:
0. There is a cross mark "X" on the Table' icon.
          You may found that all operations aren't work.
1. Right Click table > select "Coprocessor" > Selet "Register"

沒有留言:

張貼留言