Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-6806

CREATE TABLE should support STORED AS AVRO

          Details

          • Hadoop Flags:
            Reviewed
          • Release Note:
            Hide
            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.
            Show
            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.

            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.

              Attachments

              1. HIVE-6806.patch
                48 kB
                Ashish Singh
              2. HIVE-6806.1.patch
                50 kB
                Ashish Singh
              3. HIVE-6806.2.patch
                64 kB
                Ashish Singh
              4. HIVE-6806.3.patch
                77 kB
                Ashish Singh

                Issue Links

                duplicates

                Improvement - An improvement or enhancement to an existing feature or task. HIVE-3159 Update AvroSerde to determine schema of new tables

                • Major - Major loss of function.
                • Resolved
                is depended upon by

                Test - A new unit, integration or system test. HIVE-7440 Remove custom code for Avro in HCatMapReduceTest

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Resolved
                is related to

                New Feature - A new feature of the product, which has yet to be developed. HIVE-7446 Add support to ALTER TABLE .. ADD COLUMN to Avro backed tables

                • Major - Major loss of function.
                • Closed

                Task - A task that needs to be done. HIVE-8591 hive.default.fileformat should accept all formats described by StorageFormatDescriptor

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Patch Available
                relates to

                Task - A task that needs to be done. HIVE-5976 Decouple input formats from STORED as keywords

                • Major - Major loss of function.
                • Closed

                  Activity

                    People

                    • Assignee:
                      rem120 Jeremy Beard
                      Reporter:
                      rem120 Jeremy Beard
                    • Votes:
                      1 Vote for this issue
                      Watchers:
                      15 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: