Category Archives: Hive-HBase

Query Hbase tables from Hive

Here is a simple example of querying Hbase data using Hive Step 1: Create a table in HBase $hbase shell hbase(main):002:0>create 'hbase_table','colfam1' Step 2: Insert data into HBase table (I am randomly populating the table) hbase(main):002:0> for i in 1..100 do for j in 1..100 do \ put 'hbase_table', "row-#{i}#{j}","colfam1:val","#{j}" end end Step 3: Create… Read More »