[
https://issues.apache.org/jira/browse/KYLIN-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877647#comment-17877647
]
ASF subversion and git services commented on KYLIN-5952:
--------------------------------------------------------
Commit 220a2dffd639af5a333b21e933f841791af5fc1e in kylin's branch
refs/heads/kylin5 from Pengfei Zhan
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=220a2dffd6 ]
KYLIN-5952 Support recommendation for kylin5
**SQL-Based Model and Index Creation**
1. **Quick Model Creation:** Upload SQL files directly through the front-end
interface to rapidly create models and generate corresponding indexes.
2. **Index Optimization Recommendations:** Leverage existing models to
recommend and optimize indexes, improving query performance.
3. **Historical Query Analysis:** Generate index optimization suggestions based
on query history. Select the most profitable recommendations through
statistical analysis, which users can review and approve via the front-end
interface.
4. **Unnecessary Index Elimination:** Use statistical insights to identify and
recommend the removal of redundant indexes.
5. **Enhanced Left Join Models:** For left join models, add new dimension
tables by configuring `kylin.smart.conf.model-opt-rule=append`.
6. **Optimized Aggregation Indexes:** For excluded columns, configure
`kylin.smart.conf.propose-all-foreign-keys=false` to maximize the aggregation
of recommended indexes.
7. **Further Configuration:** For additional recommended settings, refer to the
full range of SmartConfig configurations and specific settings within the
`KylinConfigBase` class.
---------
Co-authored-by: Yifei.Wu <[email protected]>
Co-authored-by: Yifan Zhang <[email protected]>
Co-authored-by: Zhiting Guo <[email protected]>
Co-authored-by: huangfeng1993 <[email protected]>
Co-authored-by: Junqing Cai <[email protected]>
Co-authored-by: Jiale He <[email protected]>
Co-authored-by: Liang.Hua <[email protected]>
Co-authored-by: lixiang <[email protected]>
Co-authored-by: Ruixuan Zhang <[email protected]>
Co-authored-by: lionelcao <[email protected]>
Co-authored-by: Xuecheng Shan <[email protected]>
Co-authored-by: Zhimin Wu <[email protected]>
Co-authored-by: feng.zhu <[email protected]>
Co-authored-by: Cheng Hao <[email protected]>
Co-authored-by: xinbei <[email protected]>
Co-authored-by: bingfeng.guo <[email protected]>
Co-authored-by: lxian2shell <[email protected]>
> Support recommendation for Kylin5
> ---------------------------------
>
> Key: KYLIN-5952
> URL: https://issues.apache.org/jira/browse/KYLIN-5952
> Project: Kylin
> Issue Type: New Feature
> Components: Modeling
> Affects Versions: 5.0.0
> Reporter: pengfei.zhan
> Assignee: pengfei.zhan
> Priority: Major
> Fix For: 5.0.0
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
