You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Miklos Gergely (Jira)" <ji...@apache.org> on 2020/02/13 10:01:00 UTC
[jira] [Commented] (HIVE-22882) Hive: ALTER Table partition set
FILEFORMAT / SERDEPROPERTIES operation does not work with qualifying db
reference
[ 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)