[
https://issues.apache.org/jira/browse/HIVE-22882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Miklos Gergely reassigned HIVE-22882:
-------------------------------------
Assignee: Miklos Gergely
> 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)
