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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0-alpha
• Fix Version/s: 5.0-alpha
• Component/s: Modeling
• Assignee: Ruixuan Zhang
• Reporter: Ruixuan Zhang
• Created: 16/Feb/23 08:10
• Updated: 27/Feb/23 08:46
• Resolved: 27/Feb/23 08:46

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:

 

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"}'