Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Creating Hbase table with pre-splitted regions using Hive QL


Copy link to this message
-
Re: Creating Hbase table with pre-splitted regions using Hive QL
Viral Bajaria 2012-04-18, 08:05
I doubt you can do that directly through the HIVE interface right now
(atleast from what I know).

Why don't you create a wrapper around the hive create table command i.e.
write a simple java utility which will take your region split arguments,
create a hbase table in code with the pre-split criteria (you should be
able to search for examples online) and then create a hive table for the
newly created hbase table via hive thrift api  ?

-Viral

On Tue, Apr 17, 2012 at 8:51 PM, Narayanan K <[EMAIL PROTECTED]> wrote:

> Hi,
>
> I know one way is to tweak the HBaseStorageHandler class in the
> hive-hbase-handler.jar to pass a hardcoded region byte array to the
> createTable method of HBaseAdmin class and build a new jar out of it.
>
> But this is not very flexible. So I was wondering how we would be able to
> mention the regions while creating the table using Hive SQL language.
>
> I searched the web and didn't find anything matching this context.
>
> Thanks,
> Narayanan
>
>
> On Tue, Apr 17, 2012 at 8:52 PM, Narayanan K <[EMAIL PROTECTED]>wrote:
>
>> Hi,
>>
>> I wanted to create an HBase table with pre-split regions in the beginning
>> using HBase-Hive Integration.
>>
>> I have read https://cwiki.apache.org/Hive/hbaseintegration.html and I
>> wanted to know *what is the syntax for creating Hbase table with
>> pre-split regions using Hive syntax from Hive.*
>>
>> Thanks,
>> Narayanan
>>
>
>