codope commented on code in PR #12420: URL: https://github.com/apache/hudi/pull/12420#discussion_r1874240000
########## website/docs/sql_ddl.md: ########## @@ -473,8 +508,10 @@ Time taken: 0.83 seconds, Fetched 2 row(s) - Predicate on internal meta fields such as `_hoodie_record_key` or `_hoodie_partition_path` cannot be used for data skipping. Queries with such predicates cannot leverage the indexes. - Secondary index is not supported for nested fields. +- Secondary index can be created only if record index is available in the table +- Secondary index can only be used for tables using OverwriteWithLatestAvroPayload payload or COMMIT_TIME_ORDERING merge mode Review Comment: Yeah we can say, secondary index is not yet supported with EVENT_TIME and CUSTOM merge modes. -- 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]
