[jira] [Created] (HIVE-21739) Make metastore DB backward compatible with pre-catalog versions of hive.

["Aditya Shah (JIRA)" <ji...@apache.org>]

Aditya Shah created HIVE-21739:
----------------------------------

             Summary: Make metastore DB backward compatible with pre-catalog versions of hive.
                 Key: HIVE-21739
                 URL: https://issues.apache.org/jira/browse/HIVE-21739
             Project: Hive
          Issue Type: Sub-task
    Affects Versions: 2.1.1, 1.2.0
            Reporter: Aditya Shah
            Assignee: Aditya Shah


Since the addition of foreign key constraint between Database ('DBS') table and catalogs ('CTLGS') table in HIVE-18755 we are able to run a simple create database command with an older version of Metastore Server. This is due to older versions having JDO schema as per older schema of 'DBS' which did not have an additional 'CTLG_NAME' column.

The error is as follows: 
{code:java}
org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Exception thrown flushing changes to datastore)
....
java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails ("metastore_1238"."DBS", CONSTRAINT "CTLG_FK1" FOREIGN KEY ("CTLG_NAME") REFERENCES "CTLGS" ("NAME"))
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)