[jira] [Commented] (HIVE-2086) Data loss with external table

["jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-2086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13020158#comment-13020158 ] 

jiraposter@reviews.apache.org commented on HIVE-2086:
-----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/604/
-----------------------------------------------------------

Review request for hive.


Summary
-------

Review request for HIVE-2086.  The external parameters were being set, but then being zeroed out by a call to params.clear(), resulting in an external table that wasn't marked as external.


This addresses bug HIVE-2086.
    https://issues.apache.org/jira/browse/HIVE-2086


Diffs
-----

  build-common.xml 9f21a69 
  data/files/ext_test/test.dat PRE-CREATION 
  ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java 9d8919c 
  ql/src/test/queries/clientpositive/create_like.q 2edde83 
  ql/src/test/results/clientpositive/create_like.q.out 63a8939 

Diff: https://reviews.apache.org/r/604/diff


Testing
-------

Automated tests added


Thanks,

Jonathan



> Data loss with external table
> -----------------------------
>
>                 Key: HIVE-2086
>                 URL: https://issues.apache.org/jira/browse/HIVE-2086
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 0.7.0
>         Environment: Amazon  elastics mapreduce cluster
>            Reporter: Q Long
>            Assignee: Jonathan Natkins
>         Attachments: HIVE-2086.1.patch
>
>
> 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. 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira