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

[Mahendra Korepu (Jira)]

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)