[COMPASS-5665] Support the management of Columnar Indexes Created: 04/Apr/22  Updated: 16/May/22  Resolved: 10/May/22

Status: Closed
Project: Compass
Component/s: Compass
Affects Version/s: None
Fix Version/s: 1.31.3

Type: New Feature Priority: Major - P3
Reporter: Le Roux Bodenstein Assignee: Rhys Howell
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Related
related to COMPASS-5830 Do not pass `unique` option with colu... Closed
related to COMPASS-5748 Update compass indexes to shared webp... Closed
related to COMPASS-5774 Link to columnstore index documentati... Closed
Epic Link: COMPASS-5479
Story Points: 5
Documentation Changes: Not Needed
Sprint: Iteration Zanzibar, Iteration Anemone

 Description   

> in Compass, when connected to a MongoDB 6.1+, users will be able to create and delete columnar indexes and specify the index options upon creation and columnar indexes will have their dedicated type label in the list of indexes;

These following options will only show up if the mongodb server version is 6.1+.

In the create index modal:

  • a new entry in the type dropdown for columnstore
  • a new optional checkbox under options for "Columnstore Projection" that, when clicked, shows a text input where the columnstore projection's JSON can be added, just like we do for wildcard projection

 

In the index list:

  • differentiate columnar indexes

 

See Scope Doc: https://docs.google.com/document/d/1RsGAKKHtT01KoBPYV47h0x0FR0Fc_Jtn2skigpHcN4A/edit#heading=h.haavpvf17xzz



 Comments   
Comment by Githook User [ 12/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: feat(compass-indexes): Columnstore indexes support COMPASS-5665 (#3024)
Branch: os-info-telemetry
https://github.com/mongodb-js/compass/commit/db85001e74f2b356fed632355faf6e22e307fb8a

Comment by Githook User [ 11/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: feat(compass-indexes): Columnstore indexes support COMPASS-5665 (#3024)
Branch: COMPASS-5786-explain-plan-helper
https://github.com/mongodb-js/compass/commit/db85001e74f2b356fed632355faf6e22e307fb8a

Comment by Githook User [ 11/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: feat(compass-indexes): Columnstore indexes support COMPASS-5665 (#3024)
Branch: yet-another-round-of-publish-fixes
https://github.com/mongodb-js/compass/commit/db85001e74f2b356fed632355faf6e22e307fb8a

Comment by Githook User [ 11/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: feat(compass-indexes): Columnstore indexes support COMPASS-5665 (#3024)
Branch: 1.31-releases
https://github.com/mongodb-js/compass/commit/db85001e74f2b356fed632355faf6e22e307fb8a

Comment by Githook User [ 10/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: feat(compass-indexes): Columnstore indexes support COMPASS-5665 (#3024)
Branch: add-force-update-to-running-stage
https://github.com/mongodb-js/compass/commit/db85001e74f2b356fed632355faf6e22e307fb8a

Comment by Githook User [ 10/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: feat(compass-indexes): Columnstore indexes support COMPASS-5665 (#3024)
Branch: main
https://github.com/mongodb-js/compass/commit/db85001e74f2b356fed632355faf6e22e307fb8a

Comment by Githook User [ 09/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: Merge branch 'main' into COMPASS-5665-columnar-index-support
Branch: COMPASS-5665-columnar-index-support
https://github.com/mongodb-js/compass/commit/8a7c4b7af3ac264d5a6b242b3f83c01f7cbaa9b0

Generated at Wed Feb 07 22:40:21 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.