Hello! What’s efficient way to filter records in c...
# general
p
Hello! What’s efficient way to filter records in case of multi-valued colomuns, e.g. List<String>, n=4 and we want to filter all documents by 1 value in value set. Is forward and inverted index efficient here? Or is better to split mutli vals column to more columns? What’s recommended design for: 1. for fix N, 2. for variable N (e.g. 1 to 10) Thank you
m
Inv index works for MV columns as well. You want to make sure that the semantics of MV columns serves your purpose, if so, you can use it. For example, a row will match if at least one value in the MV column matches the filter.
👍 1