GitHub user pointearth added a comment to the discussion: Pulsar SQL: support user defined indexes
I know querying with timestamp is very fast, because data in bookKeeper save timestamp as key. My suggestion is to create a non-clustered index, based on the key in bookKeeper, for example: If we want to create an index on the field name, We can create indexItem as map[name, List<__publish_time__>] Can you supply some describe the source code around this? and then we can discuss it again. GitHub link: https://github.com/apache/pulsar/discussions/18763#discussioncomment-4321913 ---- This is an automatically sent email for dev@pulsar.apache.org. To unsubscribe, please send an email to: dev-unsubscr...@pulsar.apache.org