manticoresoftware / manticoresearch

Easy to use open source fast database for search | Good alternative to Elasticsearch now | Drop-in replacement for E in the ELK soon
https://manticoresearch.com
GNU General Public License v3.0
8.87k stars 490 forks source link

Add command to show available secondary indexes #2479

Open glookka opened 1 month ago

glookka commented 1 month ago

Proposal:

Secondary indexes that are built over json attributes do json flattening and type auto-detection. However, currently there's no way to see the flattened attributes and their types. We need to add some command like SHOW TABLE <name> INDEXES that will display available secondary indexes, their types and whether they are enabled or disabled by updates.

Checklist:

To be completed by the assignee. Check off tasks that have been completed or are not applicable.

- [ ] Implementation completed - [ ] Tests developed - [ ] Documentation updated - [ ] Documentation reviewed - [ ] Changelog updated - [x] OpenAPI YAML updated and issue created to rebuild clients
sanikolaev commented 1 month ago

LIKE also makes sense since the list may be long due to json secondary indexes.