yes you can Register table in hive based in hbase CREATE EXTERNAL TABLE IF NOT EXISTS DB_NAME.TABLE_NAME(COL1 STRING,COL2 STRING,COL3 STRING) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:COL2,cf:COL3") TBLPROPERTIES ("hbase.table.name" = "HBASE_TABLE_NAME", "hbase.mapred.output.outputtable" = "HBASE_TABLE_NAME");
On 11 March 2016 at 16:49, ram kumar <ramkumarro...@gmail.com> wrote: > Hi, > I have a HBase table with rowkey and column family. > Is it possible to map HBase table to hive table? > > Thanks >