<maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>

    http://apix.cn/services/show/19
    http://apix.cn/services/show/20

    手机归属地查询
    表名称: phone ; rowkey: 电话号码前7位; 列簇： cf; 列：province, city, operator
    根据城市名称查询天气
    表名称: weatherjson; rowkey: 城市名称+“；”+日期; 列簇: def; 列：wind_power, post_code, high_temp, temp, time, weather, low_temp, wind_direction, city_code
                    列簇: cf; 列： json
    具体调用细节请参考WebAPIServer类    

    CREATE EXTERNAL TABLE hbase_phone(phone_num int, province string, city string, operator string)
    STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
    WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:province,cf:city,cf:operator")  
    TBLPROPERTIES ("hbase.table.name" = "phone");
    
    CREATE EXTERNAL TABLE hbase_pm25(key string, city string, class string,pm25 int, primary string)
    STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
    WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:city,cf:class,cf:pm25,cf:primary")
    TBLPROPERTIES("hbase.table.name"="pm25");
    
    CREATE EXTERNAL TABLE hbase_traininfo(key string, json string)
        STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
        WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:json")
        TBLPROPERTIES("hbase.table.name"="traininfo");

    对json编码与解码是时使用的是org.json库，JSONHelper可以直接将json字符串转换为对象。

请参考 hbase 官方网站
对于普通用户使用了自带的python ，需要进入thrift-0.9.3/lib/py 手动安装python的thrift 组件

对于用ambari + hdp 安装的hbase，其thrift在/usr/hdp/current/hbase-client/include/thrift目录下,启动thrift2时拷贝hbase2.thrift

thrift -r --gen py hbase2.thrift

class HbaseAccess(object):
def __init__(self, host, port):
    self.hbaseThriftHost = host
    self.hbaseThriftPort = port
    trans = TSocket.TSocket(self.hbaseThriftHost, self.hbaseThriftPort)
    self.transport = TTransport.TBufferedTransport(trans)
    protocol = TBinaryProtocol.TBinaryProtocol(self.transport)
    self.client = THBaseService.Client(protocol)
    self.transport.open()
"""

"""
def put(self, tbName, rowKey, data):

    cols = []
    for (key, value) in data.items():
        cols.append(TColumnValue(key.split(':')[0], key.split(':')[1], value))

    self.client.put(tbName, TPut(rowKey, cols))

def get(self,tbName, rowKey, cols = None):

    if cols:
        lst = []
        for col in cols:
            lst.append(TColumnValue(col.split(':')[0], col.split(':')[1]))
        get = TGet(rowKey,lst)
    else:
        get = TGet(rowKey)
    result = self.client.get(tbName, get)
    dic = dict()
    for col in result.columnValues:
        dic[col.family + ':' + col.qualifier] = col.value
    return  dic

def __del__(self):
    self.transport.close()

/usr/hdp/current/hbase-master/bin/hbase-daemon.sh start thrift2