[
https://issues.apache.org/jira/browse/KYLIN-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruixuan Zhang updated KYLIN-5450:
---------------------------------
Description:
Using API to update index plan, if the shard_by_columns are not included in the
index col_order, the index plan can be saved in the metadata which causes error
while building the index.
The error can be reproduced by using api as following:
{code:java}
curl -X POST \
http://host:port/kylin/api/index_plans/table_index \
-H 'accept: application/vnd.apache.kylin-v4+json' \
-H 'accept-language: en' \
-H 'authorization: Basic QURNSU46S1lMSU4=' \
-H 'cache-control: no-cache' \
-H 'content-type: application/json' \
-H 'postman-token: fb63f31f-d8d2-b728-3f3b-553e38b02cb2' \
-d
'{"id":"","col_order":["TF_FACTS_LEADS_DAY.NEW_INTENTIONS"],"sort_by_columns":[],
\
"shard_by_columns":["TF_FACTS_LEADS_DAY.NEW_LEADS"],"load_data":false,"index_range":"EMPTY","project":"SFM","model_id":"290c552c-c38f-ea8f-8c18-e7850d7419cc"}'{code}
was:
Using API to update index plan, if the shard_by_columns are not included in the
index col_order, the index plan can be saved in the metadata which causes error
while building the index.
The error can be reproduced by using api such as
{code:java}
curl -X POST \
http://host:port/kylin/api/index_plans/table_index \
-H 'accept: application/vnd.apache.kylin-v4+json' \
-H 'accept-language: en' \
-H 'authorization: Basic QURNSU46S1lMSU4=' \
-H 'cache-control: no-cache' \
-H 'content-type: application/json' \
-H 'postman-token: fb63f31f-d8d2-b728-3f3b-553e38b02cb2' \
-d
'{"id":"","col_order":["TF_FACTS_LEADS_DAY.NEW_INTENTIONS"],"sort_by_columns":[],
\
"shard_by_columns":["TF_FACTS_LEADS_DAY.NEW_LEADS"],"load_data":false,"index_range":"EMPTY","project":"SFM","model_id":"290c552c-c38f-ea8f-8c18-e7850d7419cc"}'{code}
> If shardBy columns are not included in the index col orders, building the
> index will fail
> -----------------------------------------------------------------------------------------
>
> Key: KYLIN-5450
> URL: https://issues.apache.org/jira/browse/KYLIN-5450
> Project: Kylin
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 5.0-alpha
> Reporter: Ruixuan Zhang
> Assignee: Ruixuan Zhang
> Priority: Major
> Fix For: 5.0-alpha
>
>
> Using API to update index plan, if the shard_by_columns are not included in
> the index col_order, the index plan can be saved in the metadata which causes
> error while building the index.
> The error can be reproduced by using api as following:
>
> {code:java}
> curl -X POST \
> http://host:port/kylin/api/index_plans/table_index \
> -H 'accept: application/vnd.apache.kylin-v4+json' \
> -H 'accept-language: en' \
> -H 'authorization: Basic QURNSU46S1lMSU4=' \
> -H 'cache-control: no-cache' \
> -H 'content-type: application/json' \
> -H 'postman-token: fb63f31f-d8d2-b728-3f3b-553e38b02cb2' \
> -d
> '{"id":"","col_order":["TF_FACTS_LEADS_DAY.NEW_INTENTIONS"],"sort_by_columns":[],
> \
>
> "shard_by_columns":["TF_FACTS_LEADS_DAY.NEW_LEADS"],"load_data":false,"index_range":"EMPTY","project":"SFM","model_id":"290c552c-c38f-ea8f-8c18-e7850d7419cc"}'{code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
