HI Jaydeep, The ability to change column names first became available in Hive 0.5. This feature is not present in Hive 0.4.1 or any earlier release. I tried your example on Hive 0.4.1 and verified that it fails with the same error. It works on Hive 0.5.
Thanks. Carl On Mon, Jun 14, 2010 at 11:28 PM, jaydeep vishwakarma < [email protected]> wrote: > Hi, > > I just copied and pasted hive tutorial example. I dont know why column > rename is working, > > I ran following statement: > > hive> CREATE TABLE test_change (a int, b int, c int); > OK > Time taken: 0.227 seconds > hive> ALTER TABLE test_change CHANGE a a1 INT; > FAILED: Parse Error: line 1:12 cannot recognize input 'test_change' in > alter statement > > > Regards, > Jaydeep > > The information contained in this communication is intended solely for the > use of the individual or entity to whom it is addressed and others > authorized to receive it. It may contain confidential or legally privileged > information. If you are not the intended recipient you are hereby notified > that any disclosure, copying, distribution or taking any action in reliance > on the contents of this information is strictly prohibited and may be > unlawful. If you have received this communication in error, please notify us > immediately by responding to this email and then delete it from your system. > The firm is neither liable for the proper and complete transmission of the > information contained in this communication nor for any delay in its > receipt. >
