[jira] [Assigned] (KYLIN-5445) Epoch tables of metadata are created without primary key, which results in failure of creating table under specific versions of database

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

     [ https://issues.apache.org/jira/browse/KYLIN-5445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ruixuan Zhang reassigned KYLIN-5445:
------------------------------------

    Assignee: Ruixuan Zhang

> Epoch tables of metadata are created without primary key, which results in failure of creating table under specific 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
>            Assignee: Ruixuan Zhang
>            Priority: Major
>             Fix For: 5.0-alpha
>
>
> When KYLIN using jdbc to create epoch table, sometimes creating table will results in failure under certain versions of database due to that table not specifying 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)