Partition Hive Table to Hbase Handler ?

[#1]

Hi,

I use CDH

I have a partition table in Hive . Its a date partition. Its a month data. So there will be 30 to 31 partitions in hive.

Now the same table in hive can i move to Hbase?

I know to create a external table in hive which points to Hbase. and I know to create a partition table in Hive. Now how to integrate both. Partition I must use static partition for this use case? . any other suggestions?

I have a 100 millions records for a month data and i want to move to hbase and write a impala query for retrieval for good performance.

What i do is i create a staging table in hive and move to hbase .

Now i need to have partitions in hive. In this case how can i proceed.

For my use case i want to move the data and select it for display. I m not going to do any sort of processing.

Since i have millions of records in a month i wan to go for daily partitions and move records to date partitions so when i write a select query my response time would be fast.

Thanks