Posts: 24
Registered: ‎08-29-2017

Can we create a external table in Hive with HBase Handler with store as AVRO

create external table tablename(hbid string, MV double, C string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping"=":key,RAW:MV,RAW:C") TBLPROPERTIES (""="capacity") stored as avro

I need to store my table in a optimized way so i prefer to store my table as avro. is it possible.

My table is in hbase . i created a external table in Hive and pointed to the hbase location.

any other suggestions for storing in a optimized way?