kylin icon indicating copy to clipboard operation
kylin copied to clipboard

KYLIN-5748 Skip build flat table for index build job if all new created indexes can be built from existed parent index

Open zznlime opened this issue 2 years ago • 3 comments

For an index build job, if all the new added indexes can be built from their existed parent index. No index was built from new created flat table. For this case, there won't be any data inconsistency across indexes. And there is no need to build a new flat table to serve the stage of index build by layer. So I think we can skip stage BUILD DICT and stage GENERATE FLAT TABLE for an index build job in condition that all new added indexes can be built from their existed parent index

zznlime avatar Dec 26 '23 06:12 zznlime

@hit-lacus PTAL, Thanks

zznlime avatar Dec 26 '23 07:12 zznlime

Your proposal will be invalid in this use case: if you add a new bitmap type metric to the model, you can build the new index separately, and the task type is also INDEX_BUIDL. If you skip building the dictionary, an error will occur when generating encoding columns for the flat table later.

Mrhs121 avatar Mar 26 '24 17:03 Mrhs121

@zznlime Does this pr need to be merged into the kylin code? If necessary, please send pr to @liyang-kylin . I will resolve this issue.

pfzhan avatar Sep 02 '24 11:09 pfzhan