GitHub user KannarFr created a discussion: Pulsar SQL: support user defined indexes
**Is your feature request related to a problem? Please describe.** Currently, there is no index used to query topic using presto. `__publish_time__` can be considered as index because of ledger storage way but it's not a real one. **Describe the solution you'd like** AvroSchema used to insert to topic should comes with a indexes definition. Since then, we should be able to have managedledger for indexes referencing classical managedledgers or messageid? And then configure pulsar presto impl to use user defined indexes from schema. (This is a suggestion to initialize the discussion, as @jerrypeng and I discussed it's a large discussion to have). **Describe alternatives you've considered** There are probably multiples ways to do it, feel free to suggest your pov. **Additional context** Reduce the query runtime. GitHub link: https://github.com/apache/pulsar/discussions/18763 ---- This is an automatically sent email for dev@pulsar.apache.org. To unsubscribe, please send an email to: dev-unsubscr...@pulsar.apache.org
