Need some feedback on the star tree index.

"tableIndexConfig" : {
    "starTreeIndexConfigs":[{
      "maxLeafRecords": 1000,
      "functionColumnPairs": ["DISTINCT_COUNT_HLL__user_id","COUNT__dt"],
      "dimensionsSplitOrder": ["dt","dim1","dim2","dim3","dim4"]
    }],
    "enableDynamicStarTreeCreation" : true
  },

This is to optimise following queries.

select dt,DISTINCT_COUNT_HLL(user_id) FROM TABLE GROUP BY dt
select dt,count(1) FROM TABLE GROUP BY dt
select dt,dim2,DISTINCT_COUNT_HLL(user_id) FROM TABLE where dim1 = 3 GROUP BY dt, dim2 
select dt,dim2,count(1) FROM TABLE where dim1 = 3 GROUP BY dt, dim2

dim1,2,3,4 does not have too much high cardinality. User_id has the biggest cardinality.

Seems good to me. @User?

Yeah, lgtm

Thanks