Add index creation during mat view creation
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 17.3k
- Forks
- 1.6k
- Avg merge
- 5d 10h
- Merged PRs (30d)
- 28
Description
Is your feature request related to a problem?
We already support indexing symbols on matviews, but only after view is created. It would be nice to have them available also during matview creation. Note when we add this, the show create statement will need to be updated as well
Describe the solution you'd like.
No response
Describe alternatives you've considered.
No response
Full Name:
javier
Affiliation:
questdb
Additional context
No response
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start at the materialized-view creation path and the SHOW CREATE statement handling, using the existing symbol-index support added in pull request #5961 as context. Trace how indexes are represented after view creation, then determine the corresponding creation-time behavior and update SHOW CREATE output; done means indexes can be declared during matview creation and are reflected in the statement.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100