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

Creating an external table using the 'LIKE' clause actually creates a managed table.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 0.7.1
    • 0.8.0
    • Metastore
    • None

    Description

      When creating a new table with both the EXTERNAL and LIKE clauses, the new table does not behave as an EXTERNAL table thus resulting in potential data loss.

      Example:
      create external table test1 (VAL string) location '/user/craig/test1';
      create external table test2 like test1 location '/user/craig/test2';
      drop table test1;

      /user/craig/test1 - still exists

      drop table test2;

      /user/craig/test2 - is deleted (bad)

      If I do an extended describe on both tables, test1 shows up as being external while test2 is a managed table.

      Attachments

        Activity

          People

            Unassigned Unassigned
            fistan684 Craig Swift
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

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