Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Joining tables in hbase

Solved Go to solution
Highlighted

Joining tables in hbase

New Contributor

Hi guys,

I have table employer like below in hbase

1 column=personal_data:age, timestamp=1472494356226, value=28

1 column=personal_data:name, timestamp=1472494329458, value=Kishore

2 column=personal_data:age, timestamp=1472494969330, value=35

2 column=personal_data:name, timestamp=1472494969330, value=Gopi


I have another table Department like below in hbase


1 column=personal_data:age, timestamp=1472494356333, value=28

1 column=personal_data:department, timestamp=1472494329433, value=Admin

2 column=personal_data:age, timestamp=1472494969345, value=35

2 column=personal_data:deparment, timestamp=1472494962340, value=IT


Can we join these two tables in hbase without using spark-scala and without loading this in to hive (since we can join these loading in to hive)

I want to join these two tables in hbase only. Can we achieve this ??????

Any suggestions would be appreciated.



1 ACCEPTED SOLUTION

Accepted Solutions

Re: Joining tables in hbase

Super Collaborator

A join itself is not implemented by HBase:

see here: http://hbase.apache.org/0.94/book/joins.html or https://community.hortonworks.com/questions/29295/hbase-for-joins.html

You'll have to consider alternatives, spark-scala is one of it. Normally you don't store tables in any way normalized in Hbase.

1 REPLY 1

Re: Joining tables in hbase

Super Collaborator

A join itself is not implemented by HBase:

see here: http://hbase.apache.org/0.94/book/joins.html or https://community.hortonworks.com/questions/29295/hbase-for-joins.html

You'll have to consider alternatives, spark-scala is one of it. Normally you don't store tables in any way normalized in Hbase.