You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Ruixuan Zhang (Jira)" <ji...@apache.org> on 2023/02/16 08:13:00 UTC
[jira] [Updated] (KYLIN-5450) If shardBy columns are not included in the index col orders, building the index will fail
[ 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)