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 <knarayana...@gmail.com> 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 <knarayana...@gmail.com>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 >> > >
