Your summary "I write query normally to query the desired column and Kylin uses the index mechanism to accelerate query" is almost right. And I cannot understand exactly what your question is.
------------------------ With warm regard Xiaoxiang Yu On Wed, Nov 22, 2023 at 5:32 PM Nam Đỗ Duy <na...@vnpay.vn.invalid> wrote: > Dear Sir / Madam > > I've searched the web but cannot find the way to use measures of Kylin, for > example, with this quote from the URL of document, it seems that the > measure's magic is as follows: "I write query normally to query the desired > colummn and Kylin uses the index mechanism to accelerate query", can you > please advise? > > Count Distinct (Precise) | Welcome to Kylin 5 (apache.org) > < > https://kylin.apache.org/5.0/docs/modeling/model_design/measure_design/count_distinct_bitmap > > > > Once the measure is added and the model is saved, you need to go to the > Edit > Aggregate Index page, add the corresponding dimensions and measures to the > appropriate aggregate group according to your business scenario, and the > new aggregate index will be generated after submission. You need to build > index and load data to complete the precomputation of the target column. > You can check the job of Build Index in the Job Monitor page. After the > index is built, you can use the Count Distinct (Precise) measure to do some > querying. >