Jackie-Jiang commented on issue #12429: URL: https://github.com/apache/pinot/issues/12429#issuecomment-2038564631
Pinot `MV` semantic works as following: - In filter, it is similar to unnest, but each row can only be matched once (e.g. IN (1, 2) will make the row once even if the value contains both 1 and 2) - In group-by, it is treating each value as a separate group (same as unnest) - In project, the whole MV is projected as an array (different from unnest) - `VALUE_IN` is built as a workaround to do extra filter during project -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
