Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

New Contributor

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

1 REPLY 1

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