You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by ram kumar <ra...@gmail.com> on 2016/04/04 14:13:44 UTC
HBase table map to hive
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
Posted by naga sharathrayapati <sh...@gmail.com>.
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 <wo...@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 <ra...@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
Posted by Wojciech Indyk <wo...@gmail.com>.
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 <ra...@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
Posted by Wojciech Indyk <wo...@gmail.com>.
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 <ra...@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