Re: Rename external table, including HDFS directory

2013-03-09 Thread Ramki Palle
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

Rename external table, including HDFS directory

2013-03-07 Thread Keith Wiley
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

Re: Rename external table, including HDFS directory

2013-03-07 Thread Thiruvel Thirumoolan
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

Re: Rename external table, including HDFS directory

2013-03-07 Thread Dean Wampler
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 kwi...@keithwiley.com wrote: My understanding is that renaming and external table doesn't rename