[jira] [Commented] (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

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-5332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17646547#comment-17646547 ] 

ASF subversion and git services commented on KYLIN-5332:
--------------------------------------------------------

Commit 82516523250251fbf6ed6a1570eb3789b54b7e13 in kylin's branch refs/heads/kylin5 from songzhxlh-max
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=8251652325 ]

KYLIN-5332 Query select star expose column from dataflow


> 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
>            Priority: Major
>             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)