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.

Optimized way of storing the table in HIVE

Optimized way of storing the table in HIVE

New Contributor
 
2 REPLIES 2

Re: Optimized way of storing the table in HIVE

External Table Means

1. Data is already present , with certain properties like compression , partition , every record in file has certain way to identify and interpret columns etc.

2. When you map Hive to the external table it should have the same attributes of what data has when it was stored in HDFS.

3. If you had enabled compression on Hbase then hive will automatically detect.

Highlighted

Re: Optimized way of storing the table in HIVE

No, you can't specify any encoding scheme and compression for HBase table from hive, you need to do it from the HBase shell.

There are limited encoding schemes which are applicable for HFile(FASTDIFF,DIFF,PREFIX) and doesn't include Avro but you can store Avro data in HBase column and define the schema for that data by using Hive.


https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration#HBaseIntegration-AvroDataStoredinH...