Re: HBase table map to hive

2016-04-06 Thread naga sharathrayapati
If your schema is changing frequently I think it's better to use Avro for schema evolution, and go with 'Avro Serde' with 'AvroContainerInputFormat' & 'AvroContaineOutputFormat' for creating table in Hive from Hbase. On Mon, Apr 4, 2016 at 1:19 PM, Wojciech Indyk wrote: > Hi! > You can use map

Re: HBase table map to hive

2016-04-04 Thread Wojciech Indyk
Hi! You can use map on your column family or a prefix of column qualifier. https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration#HBaseIntegration-HiveMAPtoHBaseColumnFamily -- Kind regards/ Pozdrawiam, Wojciech Indyk http://datacentric.pl 2016-04-04 14:13 GMT+02:00 ram kumar : > Hi,

HBase table map to hive

2016-04-04 Thread ram kumar
Hi, I have a hbase table with column name changes (increases) over time. Is there a way to map such hbase to hive table, inferring schema from the hbase table? Thanks

Re: HBase table map to hive

2016-03-11 Thread Divya Gehlot
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.t

HBase table map to hive

2016-03-11 Thread ram kumar
Hi, I have a HBase table with rowkey and column family. Is it possible to map HBase table to hive table? Thanks