hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: how to search the archive
Date Fri, 04 Dec 2015 16:15:03 GMT
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.garza@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:tysaito@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.garza@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:awhan@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
>

Mime
View raw message