Hbase Table from HBase query

[Sandeep Kommineni]

Is there anyway we can create a Hbase table as an output of hbase query? Suppose I have a huge hbase table and then I query the hbase table using filter. I want to store the result back into Hbase table. Is it possible? You can take snapshot of your running Hbase table and export it to the HDFS . Write Mapreduce to get data as you want in a file and then Bulk Load to new Hbase table . You can directly write data into Hbase table also . In that way running MapReduce on Snapshot will not impact the actual Hbase table also . This is how you can do all steps are mentioned below You can use hbase as source and sink for a map reduce. I hope this will help you. refer to 7.2.4 section. Since you will be writing put as output in parallel, the time is also optimized. You cannot directly query hbase and create another table in it which contains your output but you can write map reduce to do the same. Apart from map reduce, if you would use Apache Phoenix over your hbase to do so, you will be able to write a query to select the data and store it into hbase table.