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

CREATE TABLE should support STORED AS AVRO

    XMLWordPrintableJSON

    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.3.patch
          77 kB
          Ashish Singh
        3. HIVE-6806.2.patch
          64 kB
          Ashish Singh
        4. HIVE-6806.1.patch
          50 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: