Hi. How do I know if star-tree index is ready ? There seems to be no improvement.

numDocsScanned

remains the same. My index config and query are like follow:

"starTreeIndexConfigs": [
        {
          "dimensionsSplitOrder": [
            "id",
            "A",
            "B",
            "C",
            "D"
          ],
          "functionColumnPairs": [
            "DISTINCT_COUNT_HLL__id"
          ],
          "maxLeafRecords": 10000
        }
      ]

Query:

SELECT DISTINCTCOUNTHLL(id), A FROM MyTable WHERE B = 'a' GROUP BY A ORDER BY DISTINCTCOUNTHLL(id) DESC LIMIT 20

What is count(*) where B=‘b’ ?

@Mayank Sry if Im not clear enough.

B

is the field name,

b

is the value

Hey @Bowen Wan I was just trying to see that if you apply count(*) on your predicate, how many records are picked, and if it is below the maxLeafRecords threshold

@Mayank I see. There should be about 2-4M records if I apply count(*). Based on my understanding, I feel it will need to further split the node