Re: Creating Hbase table with pre-splitted regions using Hive QL

2012-04-18 Thread Viral Bajaria
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 criter

Re: Creating Hbase table with pre-splitted regions using Hive QL

2012-04-17 Thread Narayanan K
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 regio

Re: Creating Hbase table with pre-splitted regions using Hive QL

2012-04-17 Thread Sukhendu Chakraborty
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