[ https://issues.apache.org/jira/browse/HIVE-22882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17036094#comment-17036094 ]
Miklos Gergely commented on HIVE-22882: --------------------------------------- [~korepum] could you please provide a cluster where I can see the issue? I've tried to reproduce it, but working fine for me on master. > 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 > Assignee: Miklos Gergely > Priority: Minor > > 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)