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

Add test coverage for external table data loss issue

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.7.0
    • Fix Version/s: 0.8.0
    • Component/s: Metastore
    • Labels:
      None
    • Environment:

      Amazon elastics mapreduce cluster

    • Hadoop Flags:
      Reviewed
    • Tags:
      data loss external table create like

      Description

      Data loss when using "create external table like" statement.

      1) Set up an external table S, point to location L. Populate data in S.
      2) Create another external table T, using statement like this:
      create external table T like S location L
      Make sure table T point to the same location as the original table S.
      3) Query table T, see the same set of data in S.
      4) drop table T.
      5) Query table S will return nothing, and location L is deleted.

        Attachments

        1. create_like.q.out
          14 kB
          Ning Zhang
        2. HIVE-2086.1.patch
          18 kB
          Jonathan Natkins
        3. HIVE-2086.2.patch
          17 kB
          Jonathan Natkins
        4. HIVE-2086.3.patch
          14 kB
          Jonathan Natkins

          Issue Links

            Activity

              People

              • Assignee:
                natty Jonathan Natkins
                Reporter:
                qlong Q Long
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: