Hi, how to tune query performance like ‘select count(distinct user_id) from table_name’? When I run such a query, it returned several servers not responded. 😂 This table has about 100million rows and inverted_index is created for user_id.

Do you want accurate number or ok with approximation? If latter, try HLL. If former, try partition based distinct count