GitHub user KannarFr added a comment to the discussion: Pulsar SQL: support user defined indexes
@pointearth @sijie How do you imagine the index composition regarding ledgers? As the first implementation, regarding pub/sub system, timestamp index-based would be a good start. I think we should first be able to auto-create an index per topic like: ```java Map[Date, LedgerId] ``` Or maybe ```java Map[Date, IndexItem] IndexItem(PreviousLedgerId, LedgerId, NextLedgerId) ``` WDYT? Maybe we should directly point to message and not ledger. GitHub link: https://github.com/apache/pulsar/discussions/18763#discussioncomment-4321911 ---- This is an automatically sent email for dev@pulsar.apache.org. To unsubscribe, please send an email to: dev-unsubscr...@pulsar.apache.org