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

Does HIVE support SQL 99 'WITH' clause yet? I dod not find  definitive
answer in the web. I am in thr process of installing HIVE locally, but
wanted to check with you before trying it.

Thanks,
-Sukhendu

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
>

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