Hive通过外部表的方式访问HBase中的表

**

Create hive external table to access hbase table

**

HBase数据库中的表数据量都比较大，由于HBase不易查询，需要借助Hive对数据进行查询分析。这时就需要让Hive能够直接访问HBase里面的数据表，而不需要将数据在Hive里面复制一份。
下面做一个演示：

1. 在HBase中新建一张测试表customer
   hbase(main):001:0> create ‘customer’,‘address’,‘order’
   Created table customer
   Took 5.0601 seconds

2. 插入几条测试数据
   hbase(main):004:0> put ‘customer’,‘john’,‘address:city’,‘Boston’
   Took 0.1885 seconds
   hbase(main):005:0> put ‘customer’,‘john’,‘address:state’,‘Mashitushes’
   Took 0.0437 seconds
   hbase(main):006:0> put ‘customer’,‘john’,‘address:steet’,‘street1’
   Took 0.0424 seconds
   hbase(main):007:0> put ‘customer’,‘john’,‘order:number’,‘ORD-15’
   Took 0.0477 seconds
   hbase(main):008:0> put ‘customer’,‘john’,‘order:amount’,‘28’
   Took 0.0386 seconds

   hbase(main):010:0