I believe I can answer my own question: HIVE-1514 was committed on
08/10; my Hive was built on 08/09...

On Mon, Aug 23, 2010 at 7:25 PM, Leo Alekseyev <dnqu...@gmail.com> wrote:
> 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
>

Reply via email to