-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 ?
On Tue, Apr 17, 2012 at 8:51 PM, Narayanan K <[EMAIL PROTECTED]> wrote:
> 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.
> On Tue, Apr 17, 2012 at 8:52 PM, Narayanan K <[EMAIL PROTECTED]>wrote:
>> 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.*