Miklos Gergely created HIVE-21897:
-------------------------------------
Summary: Setting serde / serde properties for partitions
Key: HIVE-21897
URL: https://issues.apache.org/jira/browse/HIVE-21897
Project: Hive
Issue Type: Bug
Components: Hive
Affects Versions: 3.1.1
Reporter: Miklos Gergely
Assignee: Ashutosh Chauhan
Fix For: 4.0.0
According to
[https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AddSerDeProperties]
the SerDe and the SerDe properties can be set for a partition too, so
{code:java}
ALTERT TABLE table PARTITION (partition_col='partition_value') SET SERDE
'serde.class.name';{code}
Is a valid statement. In fact it is not rejected, but it is not doing anything
at all. The execution is successful, everything remains the same. The same is
true for setting the serde properties:
{code:java}
ALTER TABLE table PARTITION (partition_col='partition_value') SET
SERDEPROPERTIES ('property_name'='property_value');{code}
is also a valid statement, and not doing anything.
I suggest to modify the parser, and reject these statements. SerDe is for a
table, and not for a partition.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
