AnsweredAssumed Answered

hive-hbase Integration

Question asked by ravi0305 on Jun 16, 2014
Latest reply on Jun 16, 2014 by ravi0305
Hello All,

I am doing a hive-hbase integration.I created a table like

<code>
CREATE TABLE hbase_table_1(date string, time string, targettemp int, actualtemp int, system int, systemage int, buildingid int)
     STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
     WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:time,cf2:targettemp,cf3:actualtemp,cf4:system,cf5:systemage,cf6:buildingid")
     TBLPROPERTIES ("hbase.table.name" = "xyz");
</code>

I loaded some data into the table. everything is fine. But when i open hbase shell and when i type list

there is no xyz table .

Please solve my issue.

Outcomes