[
https://issues.apache.org/jira/browse/HIVE-22234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16937929#comment-16937929
]
Sankar Hariappan commented on HIVE-22234:
-----------------------------------------
+1, pending tests
> Hive replication fails with table already exist error when replicating from
> old version of hive.
> ------------------------------------------------------------------------------------------------
>
> Key: HIVE-22234
> URL: https://issues.apache.org/jira/browse/HIVE-22234
> Project: Hive
> Issue Type: Bug
> Reporter: mahesh kumar behera
> Assignee: mahesh kumar behera
> Priority: Major
> Labels: pull-request-available
> Attachments: HIVE-22234.01.patch
>
> Time Spent: 40m
> Remaining Estimate: 0h
>
> HIve replication from old version where HIVE-22046 is not patched will not
> have engine column set in the table column stats. This causes "ERROR: null
> value in column "ENGINE" violates not-null constraint" error during create
> table while updating the column stats. As the column stats are updated after
> the create table txn is committed, the next retry by HMS client throws table
> already exist error. Need to update the ENGINE column to default value while
> importing the table if the column value is not set. The column stat and
> create table in same txn can be done as part of separate Jira.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
