Re: Mapping existing HBase table with many columns to Hive.

2012-12-09 Thread David Koch
Hello, I tried the shell command which Swarnim kindly provided and it allows me to map an existing HBase table into Hive. However, since my qualifiers are long but map only accepts string as a key, the result is garbled. Even with the suggested patch which allows binary keys, the resulting datatyp

Re: Mapping existing HBase table with many columns to Hive.

2012-12-06 Thread David Koch
Hello Swarnim, Thank you for your answer. I will try the options you pointed out. /David On Thu, Dec 6, 2012 at 9:10 PM, kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com> wrote: > map

Re: Mapping existing HBase table with many columns to Hive.

2012-12-06 Thread kulkarni.swar...@gmail.com
Hi David, First of all, you columns are not "long". They are binary as well. Currently as hive stands, there is no support for binary qualifiers. However, I recently submitted a patch for that[1]. Feel free to give it a shot and let me know if you see any issues. With that patch, you can directly

Mapping existing HBase table with many columns to Hive.

2012-12-06 Thread David Koch
Hello, How can I map an HBase table with the following layout to Hive using the "CREATE EXTERNAL TABLE" command from shell (or another programmatic way): The HBase table's layout is as follows: Rowkey=16 bytes, a UUID that had the "-" removed, and the 32hex chars converted into two 8byte longs. C