#community-help

Faceting High Cardinality Field for Grouping in Data

TLDR Jack questioned faceting a high cardinality field for grouping, Kishore Nallan confirmed it is fine except for additional memory use.

Powered by Struct AI
Sep 14, 2023 (2 months ago)
Jack
Photo of md5-845e30d1fd9c6b076f9a8266ff9d0237
Jack
12:40 AM
is it a smart idea to facet a somewhat unique field?
like for child-parent relationship, where 3 or 4 items will share the parent_id, is it okay to group by the parent_id to display only one child item per parent_id?
My assumption was that faceting over a largely varying field is not a good idea, but I just realized I may be wrong on this.
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
02:25 AM
Group by parent ID is fine but that's different from faceting.
Jack
Photo of md5-845e30d1fd9c6b076f9a8266ff9d0237
Jack
05:29 PM
I see. In the docs, it says that
> To group on a particular field, it must be a faceted field.
so, you’re saying is that having a parent_id a faceted field is fine, right?
Sep 15, 2023 (2 months ago)
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
12:20 AM
Are you looking to count the occurrences of field values like brands, colors etc.?
Jack
Photo of md5-845e30d1fd9c6b076f9a8266ff9d0237
Jack
12:34 AM
yes
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
01:49 AM
Facets on high cardinality field should not be a problem except for extra memory usage.