You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "sibing.zhang (Jira)" <ji...@apache.org> on 2022/12/05 10:30:00 UTC

[jira] [Created] (KYLIN-5332) After turning on the switch "kylin.query.use-tableindex-answer-select-star.enabled", select * only answers the dimension in the cube, but the table index contains more columns

sibing.zhang created KYLIN-5332:
-----------------------------------

             Summary: After turning on the switch "kylin.query.use-tableindex-answer-select-star.enabled", select * only answers the dimension in the cube, but the table index contains more columns
                 Key: KYLIN-5332
                 URL: https://issues.apache.org/jira/browse/KYLIN-5332
             Project: Kylin
          Issue Type: Bug
    Affects Versions: 5.0-alpha
            Reporter: sibing.zhang
             Fix For: 5.0-alpha


该现象表现为dimension中有5个列,但是tableindex中有10个列。通过select * 查询出来的结果仅有5个列。预期是需要查询出全部的10个列。

*RootCause:*

开启开关 “kylin.query.use-tableindex-answer-select-star.enabled”后,olaptable在注册sourceColumn的时候,会根据当前table在model中查询上线的模型。如果没有找到则返回所有列,如果找到,则返回model的effectDimensions作为表的暴露列。

当前逻辑中dimension和measure会被一起写入table index,但是measure写入table index时并没有把该列设置为dimension,导致获取不到该列。查询select *的时候,则会缺少列。

*Fix Design:*

直接通过dataflow获取allColumn,这个column来源索引中的列。



--
This message was sent by Atlassian Jira
(v8.20.10#820010)