Mapping Hive Table To Phoenix Table

[Justin Workman <ju...@gmail.com>]

We are trying to map a Hive table to a Phoenix table and having problems
when we use a composite key made from several columns in the table. It
appears that these columns are not exposed independently when trying to map
to Hive because they are not actual columns in the underlying HBase table.
Is there a way around this?

We are using the HbaseStorageHandler to do the mapping and Hive 0.13 from
CDH 5.3.3

Thanks
Justin

Re: Mapping Hive Table To Phoenix Table

[James Taylor <ja...@apache.org>]

There's some work that was done to make Phoenix and Hive work well together
here: https://github.com/apache/phoenix/pull/74 and here:
https://github.com/nmaillard/Phoenix-Hive

The pull is out of date, but could likely be revived - just needs an owner
and needs to be brought over the finish line.

Thanks,
James



On Fri, Dec 11, 2015 at 9:23 AM, Justin Workman <ju...@gmail.com>
wrote:

> We are trying to map a Hive table to a Phoenix table and having problems
> when we use a composite key made from several columns in the table. It
> appears that these columns are not exposed independently when trying to map
> to Hive because they are not actual columns in the underlying HBase table.
> Is there a way around this?
>
> We are using the HbaseStorageHandler to do the mapping and Hive 0.13 from
> CDH 5.3.3
>
> Thanks
> Justin
>