Hi all, I'm looking at http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL, where there's a code example of the following: ALTER TABLE table_name [partitionSpec] SET LOCATION "new location"
However, when I try to run it, I get alter table raw_log_proc_test1_renamed2 set location '/tmp/leo/hivetmp2'; FAILED: Parse Error: line 1:12 cannot recognize input 'raw_log_proc_test1_renamed2' in alter table statement The table definitely exists; I'm using a fairly recent build of Hive. Is this a bug?.. I have some tables created outside the Hive warehouse using the LOCATION keyword; I want to make sure I can consistently rename them if need be. The "alter table foo rename to bar" on those tables moves them to Hive warehouse; I want to keep them in HDFS but outside the warehouse dir. Would appreciate any comments. Thanks, --Leo
