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

Add test coverage for external table data loss issue

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.7.0
    • 0.8.0
    • Metastore
    • None
    • Amazon elastics mapreduce cluster

    • Reviewed
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: