Hbase和Hive关联表

hbase(main):073:0> create 'kb15:customer','order','addr'


hive> create external table customer(
    > name string,
    > order_id string,
    > order_date string,
    > addr_city string,
    > addr_street string
    > )
    > stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' with 
    > serdeproperties ("hbase.columns.mapping"=":key,order:orderid,order:date,addr:city,addr:street") 
    > tblproperties("hbase.table.name"="kb15:customer");
OK

hive> insert into table customer values('tom','12345','2021-11-22','nanjing','xiaohanglu');


hive> select * from customer;
OK
tom	12345	2021-11-22	nanjing	xiaohanglu

hbase(main):067:0> put 'kb15:customer','jerry','addr:city','shanghai'
hbase(main):069:0> put 'kb15:customer','jerry','addr:street','nanjinglu'
hbase(main):071:0> put 'kb15:customer','jerry','order:date','2021-11-11'
hbase(main):072:0> put 'kb15:customer','jerry','order:orderid','54321'

hbase(main):077:0> scan 'kb15:customer'
ROW                                     COLUMN+CELL                                                                                                       
 tom                                    column=addr:city, timestamp=1637563353007, value=nanjing                                                          
 tom                                    column=addr:street, timestamp=1637563353007, value=xiaohanglu                                                     
 tom                                    column=order:date, timestamp=1637563353007, value=2021-11-22                                                      
 tom                                    column=order:orderid, timestamp=1637563353007, value=12345                                                        
1 row(s) in 0.0070 seconds