[
https://issues.apache.org/jira/browse/KYLIN-5445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruixuan Zhang updated KYLIN-5445:
---------------------------------
Description:
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.
was:
When KYLIN 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.
> 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
> 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)
