[
https://issues.apache.org/jira/browse/KYLIN-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17875728#comment-17875728
]
ASF GitHub Bot commented on KYLIN-5952:
---------------------------------------
pfzhan opened a new pull request, #2195:
URL: https://github.com/apache/kylin/pull/2195
**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: 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)
