You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Keith Wiley <kw...@keithwiley.com> on 2013/03/08 00:29:06 UTC
Rename external table, including HDFS directory
My understanding is that renaming and external table doesn't rename the corresponding HDFS directory to match. I would like to do this; I want to rename the table in Hive and also rename the HDFS directory so they match (they already match with the old name). I'm not sure how to do this. I'm worried that if I rename the HDFS directory through Hadoop, not Hive, that Hive will lose track of the directory, regardless of whether I rename the table in Hive as well.
I also don't want to drop and recreate the table because I don't want to notify Hive of all the partitions all over again.
Thoughts?
________________________________________________________________________________
Keith Wiley kwiley@keithwiley.com keithwiley.com music.keithwiley.com
"Luminous beings are we, not this crude matter."
-- Yoda
________________________________________________________________________________
Re: Rename external table, including HDFS directory
Posted by Ramki Palle <ra...@gmail.com>.
As you can run the hadoop dfs commands from inside Hive, you can put both
the commands in a script file and run the script file using hive. These are
still two different commands but are together at one place and can be
executed in the same environment in one go.
-Ramki.
On Fri, Mar 8, 2013 at 5:32 AM, Dean Wampler <
dean.wampler@thinkbiganalytics.com> wrote:
> You can rename the LOCATION with an ALTER TABLE command. I don't believe
> there's a single, "atomic" statement to rename both the table and the
> directory.
>
>
> On Thu, Mar 7, 2013 at 5:29 PM, Keith Wiley <kw...@keithwiley.com> wrote:
>
>> My understanding is that renaming and external table doesn't rename the
>> corresponding HDFS directory to match. I would like to do this; I want to
>> rename the table in Hive and also rename the HDFS directory so they match
>> (they already match with the old name). I'm not sure how to do this. I'm
>> worried that if I rename the HDFS directory through Hadoop, not Hive, that
>> Hive will lose track of the directory, regardless of whether I rename the
>> table in Hive as well.
>>
>> I also don't want to drop and recreate the table because I don't want to
>> notify Hive of all the partitions all over again.
>>
>> Thoughts?
>>
>>
>> ________________________________________________________________________________
>> Keith Wiley kwiley@keithwiley.com keithwiley.com
>> music.keithwiley.com
>>
>> "Luminous beings are we, not this crude matter."
>> -- Yoda
>>
>> ________________________________________________________________________________
>>
>>
>
>
> --
> *Dean Wampler, Ph.D.*
> thinkbiganalytics.com
> +1-312-339-1330
>
>
Re: Rename external table, including HDFS directory
Posted by Dean Wampler <de...@thinkbiganalytics.com>.
You can rename the LOCATION with an ALTER TABLE command. I don't believe
there's a single, "atomic" statement to rename both the table and the
directory.
On Thu, Mar 7, 2013 at 5:29 PM, Keith Wiley <kw...@keithwiley.com> wrote:
> My understanding is that renaming and external table doesn't rename the
> corresponding HDFS directory to match. I would like to do this; I want to
> rename the table in Hive and also rename the HDFS directory so they match
> (they already match with the old name). I'm not sure how to do this. I'm
> worried that if I rename the HDFS directory through Hadoop, not Hive, that
> Hive will lose track of the directory, regardless of whether I rename the
> table in Hive as well.
>
> I also don't want to drop and recreate the table because I don't want to
> notify Hive of all the partitions all over again.
>
> Thoughts?
>
>
> ________________________________________________________________________________
> Keith Wiley kwiley@keithwiley.com keithwiley.com
> music.keithwiley.com
>
> "Luminous beings are we, not this crude matter."
> -- Yoda
>
> ________________________________________________________________________________
>
>
--
*Dean Wampler, Ph.D.*
thinkbiganalytics.com
+1-312-339-1330
Re: Rename external table, including HDFS directory
Posted by Thiruvel Thirumoolan <th...@yahoo-inc.com>.
https://cwiki.apache.org/Hive/languagemanual-ddl.html#LanguageManualDDL-Ren
ameTable
The link mentions that it changes the directory also. If not you can
change the table name and then use "alter table <table name> set location
<new location>" Let us know what you see.
On 3/7/13 3:29 PM, "Keith Wiley" <kw...@keithwiley.com> wrote:
>My understanding is that renaming and external table doesn't rename the
>corresponding HDFS directory to match. I would like to do this; I want
>to rename the table in Hive and also rename the HDFS directory so they
>match (they already match with the old name). I'm not sure how to do
>this. I'm worried that if I rename the HDFS directory through Hadoop,
>not Hive, that Hive will lose track of the directory, regardless of
>whether I rename the table in Hive as well.
>
>I also don't want to drop and recreate the table because I don't want to
>notify Hive of all the partitions all over again.
>
>Thoughts?
>
>__________________________________________________________________________
>______
>Keith Wiley kwiley@keithwiley.com keithwiley.com
>music.keithwiley.com
>
>"Luminous beings are we, not this crude matter."
> -- Yoda
>__________________________________________________________________________
>______
>