[HIVE-22882] Hive: ALTER Table partition set FILEFORMAT / SERDEPROPERTIES operation does not work with qualifying db reference

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Assignee: Miklos Gergely
• Reporter: Mahendra Korepu
• Created: 12/Feb/20 17:01
• Updated: 17/Feb/20 13:22
• Resolved: 17/Feb/20 13:22

Description

Steps to Reproduce the issue:

Create Data set by following steps:

1.create database db1;
2.create table db1.tb1 (fn string, ln string) partitioned by (age int);
3.alter table db1.tb1 add partition (age=35);

Now run the operation : alter table db1.tb1 partition (age=35) set fileformat avro;
Actual Result :

ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter partition. Unable to alter partitions because table or database does not exist.
INFO : Completed executing command(queryId=hive_20180710121313_10c638dc-6cea-4aa4-8be7-bf584c556a84); Time taken: 0.03 seconds
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter partition. Unable to alter partitions because table or database does not exist. (state=08S01,code=1)

Expected : Should be able to run the operation with any error.

Note: Workaround solution for the issue is by appending the query with use statement : use db1; alter table db1.tb1 partition (age=35) set fileformat avro;

Env: Hive , Beeline

Issue Links

• duplicates: HIVE-17309 alter partition onto a table not in current database throw InvalidOperationException