[jira] [Created] (KYLIN-5445) Epoch tables of metadata sometimes are created without primary key through mysql, results in failure creating table using certain versions of database

["Ruixuan Zhang (Jira)" <ji...@apache.org>]

Ruixuan Zhang created KYLIN-5445:
------------------------------------

             Summary: Epoch tables of metadata sometimes are created without primary key through mysql, results in failure creating table using certain versions of database
                 Key: KYLIN-5445
                 URL: https://issues.apache.org/jira/browse/KYLIN-5445
             Project: Kylin
          Issue Type: Bug
          Components: Metadata
    Affects Versions: 5.0-alpha
            Reporter: Ruixuan Zhang
             Fix For: 5.0-alpha


KYLIN is using jdbc to create epoch table, sometimes creating table will results in failure under certain versions of database due to that table does not specify the primary key.

Therefore, the field target_epoch can be used as primary key, and its previous constraint of being unique can be removed. For the environment that the table has already exist, KYLIN will firstly check if the primary key exists, if so, then target_epoch will be added as primary key.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)