Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
MIME-Version: 1.0
Date: Mon, 24 Aug 2015 16:11:54 -0700
Message-ID: 
 <CAO6Jcph43eo-MGjPGLpzcSniBWDf6Qs99n-L250ASJzXX_1zMQ@mail.gmail.com>
Subject: Data Deleted on Hive External Table
From: Peyman Mohajerian <mohajeri@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=94eb2c0812f05153cb051e16bebd

--94eb2c0812f05153cb051e16bebd
Content-Type: text/plain; charset=UTF-8

Hi Guys,

I managed to delete some data in HDFS by dropping a partitioned external
Hive table. One explanation is that data resided in the 'warehouse'
directory of Hive and that had something to do with?
An alternative explanation may that my 'drop table' statement didn't delete
the data but my follow up 'create table' statement with a different
partition name did. Let me elaborate, files used to be in this directory
structure:
/user/hive/warehouse/<tablename>/year=2009

I created a new Hive external table with partition column name of 'yr'
instead of 'year' pointing to the same base directory. Is it possible that
this create statement deleted the data (highly doubt that)? Either case
were unexpected to me!

This is on Hive 1.0.

Thanks,
Peyman

--94eb2c0812f05153cb051e16bebd
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Guys,<div><br></div><div>I managed to delete some data =
in HDFS by dropping a partitioned external Hive table. One explanation is t=
hat data resided in the &#39;warehouse&#39; directory of Hive and that had =
something to do with?</div><div>An alternative explanation may that my &#39=
;drop table&#39; statement didn&#39;t delete the data but my follow up &#39=
;create table&#39; statement with a different partition name did. Let me el=
aborate, files used to be in this directory structure:</div><div>/user/hive=
/warehouse/&lt;tablename&gt;/year=3D2009=C2=A0</div><div><br></div><div>I c=
reated a new Hive external table with partition column name of &#39;yr&#39;=
 instead of &#39;year&#39; pointing to the same base directory. Is it possi=
ble that this create statement deleted the data (highly doubt that)? Either=
 case were unexpected to me!</div><div><br></div><div>This is on Hive 1.0.<=
/div><div><br></div><div>Thanks,</div><div>Peyman</div></div>

--94eb2c0812f05153cb051e16bebd--