Hive 或 Impala 与 Hbase表结合

1. 创建hbase表

create 'message','info','school'

2.创建hive表

CREATE EXTERNAL TABLE hivemessage (
        id int,
        name string,
        age int,
        address string,
        teacher string
    )
      STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
      WITH SERDEPROPERTIES (
      "hbase.columns.mapping" =
      ":key,info:name,info:age,school:address,school:teacher"  列簇对应hive中的列名
     )
      TBLPROPERTIES("hbase.table.name" = "student");

3.在hbase中插入数据

put 'message','1001','info:age','12'
put 'message','1001','info:name','wan'
put 'message','1001','school:address','bei'
put 'message','1001','school:teacher','shang'

4.在impala中查看数据，可以正常查看数据,然后用impala插入数据

insert into hivemessage(id,age,name,address,teacher) values(1003,23,'zga','jin','hua')

5.数据是存放在hbase表中的，好处在于可以用impala工具方便的查询数据。