2) Sometimes I find that managed tables are not removed from HDFS even after I drop them from the Hive shell. After a "drop table foo", foo does not show up in a "show tables" listing however that table is present in HDFS. These are not external tables.
I have noticed this as well. Sometimes this can be about the permissions of the user that created the table. For example based on the UserGroupAll + StickyBit a user might be able to create a table but another user might not be able to drop them. I had one weird issue where I could not drop a table as a different user because one of the subdirs had a sticky bit and attempting to move the sticky bit caused a failed file operation On Fri, Dec 4, 2015 at 10:33 AM, Timothy Garza < timothy.ga...@collinsongroup.com> wrote: > No, definitely not. A Hive table with Sequence Files stored in hdfs: > /user/warehouse/<tablename> > > > > > > *Kind Regards * > > > *Timothy Garza* > > Data Integration Developer > *Collinson Technology Services* > > Skype: timothy.garza.cts > > collinsongroup.com <http://www.collinsongroup.com/> > > > > [image: Collinson Group] <http://www.collinsongroup.com/> > > > > > > *From:* Takahiko Saito [mailto:tysa...@gmail.com] > *Sent:* 04 December 2015 15:12 > *To:* user@hive.apache.org > *Subject:* Re: how to search the archive > > > > Could a table be an external table? > > > > On Fri, Dec 4, 2015 at 5:56 AM, Timothy Garza < > timothy.ga...@collinsongroup.com> wrote: > > I find the same thing, especially with Hive v1.2.1 that I am currently > trialling. It does lead to issues with the Metastore when trying to re-use > the same Hive Table name and I find manually deleting the files in HDFS > serves as a workaround. > > > > Q. What does that have to do with the text in the Subject line in your > email? > > > > > > *From:* Awhan Patnaik [mailto:aw...@spotzot.com] > *Sent:* 04 December 2015 10:26 > *To:* user@hive.apache.org > *Subject:* how to search the archive > > > > Hey all! > > I have two questions: > > 1) How do I search the entire mailing list archive? > > 2) Sometimes I find that managed tables are not removed from HDFS even > after I drop them from the Hive shell. After a "drop table foo", foo does > not show up in a "show tables" listing however that table is present in > HDFS. These are not external tables. > > > > The Collinson Group Limited; Registered number: 2577557, Registered in > England & Wales; Registered Office: Cutlers Exchange, 123 Houndsditch, > London, EC3A 7BU. > > > This e-mail may contain privileged and confidential information and/or > copyright material and is intended for the use of the addressee only. If > you receive this e-mail by mistake please advise the sender immediately by > using the reply facility in your e-mail software and delete this e-mail > from your computer system. You may not deliver, copy or disclose its > contents to anyone else. Any unauthorised use may be unlawful. Any views > expressed in this e-mail are those of the individual sender and may not > necessarily reflect the views of The Collinson Group Ltd and/or its > subsidiaries or any other associated company (collectively “Collinson > Group”). > > As communications via the Internet are not secure Collinson Group cannot > accept any liability if this e-mail is accessed by third parties during the > course of transmission or is modified or amended in any way following > despatch. Collinson Group cannot guarantee that any attachment to this > email does not contain a virus, therefore it is strongly recommended that > you carry out your own virus check before opening any attachment, as we > cannot accept liability for any damage sustained as a result of software > virus infection. Senders of messages shall be taken to consent to the > monitoring and recording of e-mails addressed to members of the Company. > > > > > > -- > > Takahiko Saito >