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 01:15:06 GMT
Hi James,
The long value isn't serialized that way. There's some internal serialization logic in the
rowkey, so I'm writing a UDF to extract the long value. I looked at your tutorial for writing
UDFs, and I'm also reading up various Phoenix functions here.
Quick question - if I'm using v4.4.0, do I need to include the UDF in the Phoenix jar? JIRA
[PHOENIX-538] says that the fix version is 5.0.0 but the Phoenix UDF page says that v4.4.0
supports UDFs with the CREATE FUNCTION query.
Thank you,Anchal

     On Wednesday, July 22, 2015 5:56 PM, James Taylor <> wrote:

 If it leads with a long that was serialized using Bytes.toBytes(long), then you can map that
to the UNSIGNED_LONG type in Phoenix. What's the rest of your row key look like?
On Wed, Jul 22, 2015 at 5:54 PM, Anchal Agrawal <> wrote:

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