Zhimin Wu created KYLIN-5837: -------------------------------- Summary: After turning off the computed column function, the query cannot hit the existing recommended index Key: KYLIN-5837 URL: https://issues.apache.org/jira/browse/KYLIN-5837 Project: Kylin Issue Type: Bug Components: Query Engine Affects Versions: 5.0-beta Reporter: Zhimin Wu Assignee: Zhimin Wu Fix For: 5.0.0
*Dev Design* * The configuration parameter "kylin.metadata.only-reuse-user-defined-computed-column=false" is designed to enable the usage of user-defined computed columns for reusing only. This decouples the feature of shielding columns from the configuration, which means that the shielding column feature can still be used even with this parameter set to false. * By default, Kylin uses computed columns (CC) for implicit column conversions, which means that user-defined computed columns can replace implicit expressions. However, if the configuration parameter "kylin.query.implicit-computed-column-convert" is set to "false", the user-defined computed columns will not be used for implicit column conversions. * The configuration parameter "kylin.query.agg-computed-column-rewrite" is related to computed columns v2 and it replaces columns at the semantic RelNode level, while "kylin.query.implicit-computed-column-convert" performs column replacements at the SqlNode level. As a general rule, if "kylin.query.implicit-computed-column-convert" is set to false, then "kylin.query.agg-computed-column-rewrite" will not take effect either. However, if "kylin.query.implicit-computed-column-convert" is set to true, then "kylin.query.agg-computed-column-rewrite" can be set to either true or false. * All three configurations can now be modified at the project level. -- This message was sent by Atlassian Jira (v8.20.10#820010)