hive & hbase

[韶隆吴]

Hi all:
  I have two tables(orders,ordersitem) in Hbase and now I want to import
them into hive.
  Orders -> Ordersitem is one-to-many,and table ordersitem's keyrow is
orderid and column is
  item:1  info:1  bdinfo:1
  item:2  info:2  bdinfo:2
  to mark the items number.
  My question is how to write the HiveQL to import ordersitem