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
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  ?


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