[HIVE-6806] CREATE TABLE should support STORED AS AVRO

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.12.0
• Fix Version/s: 0.14.0
• Component/s: Serializers/Deserializers
• Labels: Avro
• Hadoop Flags: Reviewed

Release Note

Add support to infer Avro schema from Hive table schema. Avro-backed tables can simply be created by using "STORED AS AVRO" in DDL statement. AvroSerDe takes care of creating appropriate Avro schema from Hive table schema, a big win in terms of Avro usability in Hive.

• Assignee: Jeremy Beard
• Reporter: Jeremy Beard
• Created: 01/Apr/14 17:56
• Updated: 17/Jan/16 06:56
• Resolved: 25/Jul/14 18:02

Description

Avro is well established and widely used within Hive, however creating Avro-backed tables requires the messy listing of the SerDe, InputFormat and OutputFormat classes.

Similarly to HIVE-5783 for Parquet, Hive would be easier to use if it had native Avro support.

Issue Links

• duplicates: HIVE-3159 Update AvroSerde to determine schema of new tables
• is depended upon by: HIVE-7440 Remove custom code for Avro in HCatMapReduceTest
• is related to: HIVE-7446 Add support to ALTER TABLE .. ADD COLUMN to Avro backed tables
• is related to: HIVE-8591 hive.default.fileformat should accept all formats described by StorageFormatDescriptor
• relates to: HIVE-5976 Decouple input formats from STORED as keywords