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)

Reply via email to