RE: Error when altering table not in default database

Thank you! It works. Best Regards,ypg Date: Wed, 6 Aug 2014 15:48:57 -0400 Subject: Re: Error when altering table not in default database From: leftylever...@gmail.com To: user@hive.apache.org ALTER TABLE does not yet take a database qualifier on the table name, but it will soon (see HIVE

Re: Error when altering table not in default database

ALTER TABLE does not yet take a database qualifier on the table name, but it will soon (see HIVE-2584 and HIVE-4064 ). In the meantime, you can set the database before issuing ALTER TABLE, then reset

Error when altering table not in default database

Hi all,I encounter error when I was trying to alter a table not in default database. The command I type isalter table db1.table_A drop partition (id=1);Error info isFAILED: ParseException line 2:12 cannot recognize input near 'db1' '.' 'table_A' in