You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by "Kiran Kumar.M.R" <Ki...@huawei.com> on 2013/09/17 11:43:25 UTC

HBase Tables Join in Hive

Hi,
I am having 2 tables in HBase.

Table1: data, userID ( This is very big table)
Table2: userID, userDetails ( This is a smaller table)

We need to join both the table on userID column and perform some queries.

Our idea is to map both Table1 and Table2 in Hive using HBaseStorageHandler.

Does Hive support JOIN also on these HBase mapped tables?

Regards,
Kiran