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,
Yes, UDFs are as of 4.4.0. I've corrected the JIRA.
Thanks,
James
On Wed, Jul 22, 2015 at 6:15 PM, Anchal Agrawal anc...@yahoo-inc.com
wrote:
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
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,
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, etc.
If you used a different mechanism to serialize rowkey in HBase, you can
still map it Phoenix table but
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 anc...@yahoo-inc.com
wrote:
Anil and Krishna,
Thanks for your replies.
Hi,
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
(https://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table),
there's an example:
CREATE VIEW t1 ( pk VARCHAR