10-05-2017 07:58 PM
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 ("hbase.table.name"="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?