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)