[
https://issues.apache.org/jira/browse/KYLIN-5388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhenning Zhang updated KYLIN-5388:
----------------------------------
Description:
1) add root table alias for model in kylin5.0
2) add a table mapping updater
influenced metadata：
{code:java}
- table
- database name
- table name
- model
- root fact table
- join table
- computed column
- dataflow
- segments
- snapshot
- column source bytes{code}
3) add a api for table name update request
here is an example:
{code:java}
curl -kXPOST 'http://localhost:7070/kylin/api/tables/default/update' -H
'Authorization: Basic XXXXXX' \
-H 'Content-Type: application/json' \
-d '{ "mapping":{ "DEFAULT.KYLIN_SALES":
{ "database": "TEST", "tableName": "KYLIN_FACT" }
, "DEFAULT.KYLIN_CAL_DT":
{ "tableName": "CAL_DT" }
, "DEFAULT.KYLIN_CATEGORY_GROUPINGS":
{ "database": "TEST" }
}, "isUseExisting":true}'
{code}
4) add UT and json files for test.
was:
1) add root table alias for model in kylin5.0
2) add a table mapping updater
{code:java}
Get all influenced metadata
- table
- database name
- table name
- model
- root fact table
- join table
- computed column
- dataflow
- segments
- snapshot
- column source bytes{code}
3) add a api for table name update request
here is an example:
{code:java}
curl -kXPOST 'http://localhost:7070/kylin/api/tables/default/update' -H
'Authorization: Basic XXXXXX' \
-H 'Content-Type: application/json' \
-d '{ "mapping":{ "DEFAULT.KYLIN_SALES":
{ "database": "TEST", "tableName": "KYLIN_FACT" }
, "DEFAULT.KYLIN_CAL_DT":
{ "tableName": "CAL_DT" }
, "DEFAULT.KYLIN_CATEGORY_GROUPINGS":
{ "database": "TEST" }
}, "isUseExisting":true}'
{code}
4) add UT and json files for test.
> Add a rest api to support to update database name and table name without
> rebuilding data
> ----------------------------------------------------------------------------------------
>
> Key: KYLIN-5388
> URL: https://issues.apache.org/jira/browse/KYLIN-5388
> Project: Kylin
> Issue Type: Improvement
> Components: Metadata
> Affects Versions: 5.0-alpha
> Reporter: Zhenning Zhang
> Assignee: Zhenning Zhang
> Priority: Major
> Fix For: 5.0-alpha
>
>
> 1) add root table alias for model in kylin5.0
> 2) add a table mapping updater
> influenced metadata：
> {code:java}
> - table
> - database name
> - table name
> - model
> - root fact table
> - join table
> - computed column
> - dataflow
> - segments
> - snapshot
> - column source bytes{code}
>
> 3) add a api for table name update request
> here is an example:
> {code:java}
> curl -kXPOST 'http://localhost:7070/kylin/api/tables/default/update' -H
> 'Authorization: Basic XXXXXX' \
> -H 'Content-Type: application/json' \
> -d '{ "mapping":{ "DEFAULT.KYLIN_SALES":
> { "database": "TEST", "tableName": "KYLIN_FACT" }
> , "DEFAULT.KYLIN_CAL_DT":
> { "tableName": "CAL_DT" }
> , "DEFAULT.KYLIN_CATEGORY_GROUPINGS":
> { "database": "TEST" }
> }, "isUseExisting":true}'
> {code}
> 4) add UT and json files for test.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
