Jackie-Jiang commented on issue #7978: URL: https://github.com/apache/pinot/issues/7978#issuecomment-1090818377
To configure index for a sub-field of a json field, we can first extract the sub-field as a separate field through ingestion transform, then configure index on the separate field. JSON index is designed for cases where schema is not fixed across different records, and it is not as efficient as regular inverted index because we don't know the data type of the sub-fields. In your example, since we already know the data type of the sub-field, we should extract it as a separate field to get better performance and be able to configure all indexes. We may add some helper config to make the sub-field extraction more smooth (#7863), but IMO we don't need to support all index types within the `JSON_MATCH`. -- 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: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
