phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anchal Agrawal <>
Subject Re: Importing existing HBase table's rowkey
Date Thu, 23 Jul 2015 00:54:12 GMT
Anil and Krishna,
Thanks for your replies. My rowkey is made up of a LONG value with some other parameters added
in. Krishna, that's what I was looking for! I've mapped the HBase table's rowkey to the Phoenix
table, and I'm writing a UDF to extract fields from it.
- Anchal 

     On Wednesday, July 22, 2015 4:04 PM, Krishna <> wrote:

 You can map HBase composite row key to Phoenix primary key only if serialization used for
HBase matches with Phoenix. Ex: leading 1 byte for bucket, 0-byte char for separating columns,
If you used a different mechanism to serialize rowkey in HBase, you can still map it Phoenix
table but declare PK as VARBINARY and see if you can create a UDF to separate columns. 

On Tuesday, July 21, 2015, Anchal Agrawal <> wrote:


I'm trying to map an existing HBase table to Phoenix. Can the existing HBase table's rowkey
be imported as the rowkey of the Phoenix table? On this page (,
there's an example:
Here, is pk the HBase table's column that's being used as the primary key, or is it a Phoenix
keyword/placeholder to refer to the HBase table's rowkey? My table's rowkey is made up of
several fields that are not stored as columns in that table. If I could just import the rowkey
into Phoenix, that'd be great.

Thank you!

View raw message