[
https://issues.apache.org/jira/browse/KYLIN-5951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jiale He updated KYLIN-5951:
----------------------------
Summary: SQL过滤条件过太复杂导致 无法抽取过滤列/SegmentPruning失效 (was:
SQL过滤条件过太复杂导致SegmentPruning失效)
> SQL过滤条件过太复杂导致 无法抽取过滤列/SegmentPruning失效
> ----------------------------------------
>
> Key: KYLIN-5951
> URL: https://issues.apache.org/jira/browse/KYLIN-5951
> Project: Kylin
> Issue Type: Improvement
> Components: Query Engine
> Affects Versions: 5.0-beta
> Reporter: Jiale He
> Priority: Major
> Fix For: 5.0.0
>
> Attachments:
> core-1-3.c-919f2ea1b9ecceda.cn-beijing.emr.aliyuncs.com_7071_query_2024_08_01_17_33_55_F9CEE2.zip,
> error_sql_1.sql, error_sql_2.sql, image-2024-08-08-09-17-46-218.png,
> image-2024-08-08-09-20-08-345.png,
> qm_bigdata_model_metadata_2024_08_01_17_22_05_3C616E0C8A0EB198E0C55E87435E83BA.zip
>
>
> 版本：kylin5/77201e7b
> 这些sql是内部报表系统拼接的sql。
>
> 导出模型/查询诊断包(包含模型和表等元数据) 在附件中。
> h2. error_sql_1
> 过滤条件太复杂，导致过滤列没能提取出来
> !image-2024-08-08-09-17-46-218.png|width=731,height=270!
>
> h2. error_sql_2
> 过滤条件太多，导致segmentpruning失败
> 修改 kylin.query.filter-condition-count=1000 参数可以绕过这个问题。
> !image-2024-08-08-09-20-08-345.png|width=728,height=197!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
