Mahendra Korepu created HIVE-22882: -------------------------------------- Summary: Hive: ALTER Table partition set FILEFORMAT / SERDEPROPERTIES operation does not work with qualifying db reference Key: HIVE-22882 URL: https://issues.apache.org/jira/browse/HIVE-22882 Project: Hive Issue Type: Bug Reporter: Mahendra Korepu
h4.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 : {code:java} 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) {code} Expected : Should be able to run the operation with any error. h3.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; h3.Env: Hive , Beeline -- This message was sent by Atlassian Jira (v8.3.4#803005)