hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Timothy Garza <>
Subject RE: how to search the archive
Date Fri, 04 Dec 2015 15:33:12 GMT
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<>

[Collinson Group]<>

From: Takahiko Saito []
Sent: 04 December 2015 15:12
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 <<>>
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 [<>]
Sent: 04 December 2015 10:26
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

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
View raw message