Hi Everyone, Grouping on high cardinality column,...
# troubleshooting
a
Hi Everyone, Grouping on high cardinality column, we are observing discrepancy in results. We have already disabled the Server level group trimming at query level . OPTION(minServerGroupTrimSize=-1) Also in result metadata numGroupsLimitReached = false, so at segment level, threshold is not breached. Any other options to explore ? Referencing following doc: https://docs.pinot.apache.org/users/user-guide-query/grouping-algorithm
m
@Jackie
j
@Anish Nair The
numGroupsLimitReached
flag is introduced (it is not properly set before) in this PR which might not be included in the version you are running. I think highly possible you are hitting the group limit. You might need to increase the group limit and try again