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 <wojciechin...@gmail.com>
wrote:

> Hi!
> You can use map<String,something> 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 <ramkumarro...@gmail.com>:
> > 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-04-04 Thread Wojciech Indyk 
Hi!
You can use map<String,something> 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 <ramkumarro...@gmail.com>:
> 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

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.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
>

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