[jira] [Created] (KYLIN-5450) If shardBy columns are not included in the index col orders, building the index will fail

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

Ruixuan Zhang created KYLIN-5450:
------------------------------------

             Summary: 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
             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 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}
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)