From issues-return-192576-archive-asf-public=cust-asf.ponee.io@hive.apache.org Mon Jun 8 00:26:06 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id BC4E7180679 for ; Mon, 8 Jun 2020 02:26:04 +0200 (CEST) Received: (qmail 30789 invoked by uid 500); 8 Jun 2020 00:26:04 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 30690 invoked by uid 99); 8 Jun 2020 00:26:03 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Jun 2020 00:26:03 +0000 Received: from jira-he-de.apache.org (static.172.67.40.188.clients.your-server.de [188.40.67.172]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id D6B6641203 for ; Mon, 8 Jun 2020 00:26:02 +0000 (UTC) Received: from jira-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira-he-de.apache.org (ASF Mail Server at jira-he-de.apache.org) with ESMTP id 5A0767822A9 for ; Mon, 8 Jun 2020 00:26:01 +0000 (UTC) Date: Mon, 8 Jun 2020 00:26:01 +0000 (UTC) From: "ASF GitHub Bot (Jira)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Work logged] (HIVE-22234) Hive replication fails with table already exist error when replicating from old version of hive. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-22234?focusedWorklogId=442524&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-442524 ] ASF GitHub Bot logged work on HIVE-22234: ----------------------------------------- Author: ASF GitHub Bot Created on: 08/Jun/20 00:25 Start Date: 08/Jun/20 00:25 Worklog Time Spent: 10m Work Description: github-actions[bot] closed pull request #788: URL: https://github.com/apache/hive/pull/788 ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: users@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 442524) Time Spent: 1h (was: 50m) > 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, HIVE-22234.02.patch, HIVE-22234.03.patch, HIVE-22234.04.patch > > Time Spent: 1h > 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)