Reply
Highlighted
New Contributor
Posts: 1
Registered: ‎02-11-2015

How to access avro data stored in columns via HBaseStorageHandler (CDH 5.3.1)

Hi there,

 

we are using the newest version of CDH (5.3.1) and trying to access avro data that has been stored in hbase columns.

As mentioned in the relase notes the current version should include improvements that hive is now able to support avro data in hbase columns.

 

Could anyone please give an example how the HBaseStoragehandler should look like.

Especially when my columns are avro types.

 

create external table tmp_hbase (rowkey string, avro_clm which_type(?), ...)

stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'

with serdeproperties (

"hbase.columns.mapping" = ":key, cf:"

);

 

Thanks in advance

Hans

Cloudera Employee
Posts: 578
Registered: ‎01-20-2014

Re: How to access avro data stored in columns via HBaseStorageHandler (CDH 5.3.1)

Have you tried following the examples in this page?
https://cwiki.apache.org/confluence/display/Hive/AvroSerDe

If you have, could you show us the table definitions from HBase and Hive?

Regards,
Gautam Gopalakrishnan
Announcements