Hi Ibrahim
The hive hbase integration totally depends on the hbase table schema and not
the schema of the source table in mysql.
You need to provide the column family qualifier mapping in there.
Get the hbase table's schema from hbase shell.
suppose you have the schema as
Id
CF1.qualifier1
CF1.qualifier2
CF1.qualifier3
You need to match each of these ColumnFamily:Qualifier to corresponding columns
in hive.
So in hbase.columns.mapping you need to provide these CF:QL in order.
If you need to map a full CF to a hive column, the data type of the hive column
should be a Map.
You can get detailed hbase to hive integration document from hive wiki .
Regards
Bejoy KS
Sent from remote device, Please excuse typos
-----Original Message-----
From: Ibrahim Yakti <iya...@souq.com>
Date: Tue, 8 Jan 2013 15:45:32
To: user<user@hive.apache.org>
Reply-To: user@hive.apache.org
Subject: Mapping HBase table in Hive
Hello,
suppose I have the following table (orders) in MySQL:
*************************** 1. row ***************************
Field: id
Type: int(10) unsigned
Null: NO
Key: PRI
Default: NULL
Extra: auto_increment
*************************** 2. row ***************************
Field: value
Type: int(10) unsigned
Null: NO
Key:
Default: NULL
Extra:
*************************** 3. row ***************************
Field: date_lastchange
Type: timestamp
Null: NO
Key:
Default: CURRENT_TIMESTAMP
Extra: on update CURRENT_TIMESTAMP
*************************** 4. row ***************************
Field: date_inserted
Type: timestamp
Null: NO
Key:
Default: 0000-00-00 00:00:00
I imported it into HBase with column family "id"
I want to create an external table in Hive to query the HBase table, I am
not able to get the mapping parameters (*hbase.columns.mapping*), it is
confusing, if anybody can explain it to me please. I used the following
query:
CREATE EXTERNAL TABLE hbase_orders(id bigint, value bigint, date_lastchange
string, date_inserted string) STORED BY
'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES
("hbase.columns.mapping" = " ? ? ? ? ? ?") TBLPROPERTIES ("hbase.table.name"
= "orders");
Is there any way to build the Hive tables automatically or I should go with
the same process with each table?
Thanks in advanced.
--
Ibrahim
