Drop an HBase backed table

2012-12-09 Thread David Koch
Hello, How can I drop a Hive table which was created using "CREATE EXTERNAL TABLE..."? I tried "DROP TABLE ;" but the shell hangs. The underlying HBase table should not be deleted. I am using Hive 0.9 Thank you, /David

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

2012-12-09 Thread David Koch
l row keys, qualifiers and values share the same data type respectively (for example: row keys are ints, qualifiers are longs and values are strings). Thank you, /David On Thu, Dec 6, 2012 at 9:23 PM, David Koch wrote: > Hello Swarnim, > > Thank you for your answer. I will try the optio

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

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