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

Support altering partition column type in Hive

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: CLI, SQL
    • Labels:
    • Hadoop Flags:
      Reviewed
    • Release Note:
      Allow hive to change partition column type. Partition column is always converted into string. So the type checking is rely on the conversion.
    • Tags:
      alter partition column type

      Description

      Currently, Hive does not allow altering partition column types. As we've discouraged users from using non-string partition column types, this presents a problem for users who want to change there partition columns to be strings, they have to rename their table, create a new table, and copy all the data over.

      To support this via the CLI, adding a command like ALTER TABLE <table_name> PARTITION COLUMN (<column_name> <new type>);

        Attachments

        1. HIVE-3672.9.patch.txt
          89 kB
          Jingwei Lu
        2. HIVE-3672.8.patch.txt
          89 kB
          Jingwei Lu
        3. HIVE-3672.7.patch.txt
          89 kB
          Jingwei Lu
        4. HIVE-3672.6.patch.txt
          88 kB
          Jingwei Lu
        5. HIVE-3672.6.patch.txt
          88 kB
          Jingwei Lu
        6. HIVE-3672.5.patch.txt
          77 kB
          Jingwei Lu
        7. HIVE-3672.4.patch.txt
          65 kB
          Jingwei Lu
        8. HIVE-3672.3.patch.txt
          48 kB
          Jingwei Lu
        9. HIVE-3672.2.patch.txt
          44 kB
          Jingwei Lu
        10. HIVE-3672.1.patch.txt
          35 kB
          Jingwei Lu

          Activity

            People

            • Assignee:
              jingweilu Jingwei Lu
              Reporter:
              jingweilu Jingwei Lu
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 72h
                72h
                Remaining:
                Remaining Estimate - 72h
                72h
                Logged:
                Time Spent - Not Specified
                Not Specified