如何在Hbase中加入两个表 [英] How to Join two tables in Hbase

问题描述

问题：

我是Hbase的新手，遇到了需要连接两个表的情况。

让我们假设我Employee表和Department表都是在Hbase中创建的。通过阅读Hbase的行动，我知道我们不能在Hbase中加入表。解决方案：

我找到了一个解决方案，通过使用Hbase类和接口编写MapReduce代码，我们可以完成这项任务。

另外，如果有人能帮助我编码，这将是非常有用的

解决方案

最简单的方法是将您的HBase表加载到 Hive 或 Impala 并使用这些工具执行SQL连接。

Problem:

I am new to Hbase and I came across a situation where I need to join two tables.
Let us suppose I have Employee table and Department table both are created in Hbase. By reading Hbase in action , I got to know that we cannot join tables in Hbase.

Solution:

I found out a solution that by writing MapReduce Code using Hbase classes and Interfaces we can achieve this task.

Also if someone can help me with the coding that would be very helpful

解决方案

The easiest way would be to load your HBase tables into Hive or Impala and perform a SQL join with those tools.

这篇关于如何在Hbase中加入两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！