> [POLL] Centralize existing syntax or create new syntax?
1.) CREATE INDEX ... USING .... WITH OPTIONS... > [POLL] Should there be a default? (YES/NO) Yes > [POLL] What do do with the default? 3.) YAML config to override default index (legacy 2i remains the default) 4.) YAML config/guardrail to require index type selection (not required by default) For me 3 AND 4. When no type is given allow a config for the default, and add a guardrail to limit what index types are allowed.. if I misunderstood 4, I still prefer my option that we should have a allow list of types an operator is willing to support > On May 15, 2023, at 7:39 AM, Patrick McFadin <pmcfa...@gmail.com> wrote: > > 1 > Yes > 4 > > > > On Mon, May 15, 2023 at 3:00 AM Benedict <bened...@apache.org > <mailto:bened...@apache.org>> wrote: >> 3: CREATE <HNSW|LSM|SAI> INDEX (Otherwise 2) >> No >> If configurable, should be a distributed configuration. This is very >> different to other local configurations, as the 2i selected has semantic >> implications, not just performance (and the perf implications are also much >> greater) >> >>> On 15 May 2023, at 10:45, Mike Adamson <madam...@datastax.com >>> <mailto:madam...@datastax.com>> wrote: >>> >>> >>>> [POLL] Centralize existing syntax or create new syntax? >>>> >>>> 1.) CREATE INDEX ... USING .... WITH OPTIONS... >>>> 2.) CREATE LOCAL INDEX ... USING ... WITH OPTIONS... (same as 1, but adds >>>> LOCAL keyword for clarity and separation from future GLOBAL indexes) >>> >>> 1.) CREATE INDEX ... USING .... WITH OPTIONS... >>> >>>> [POLL] Should there be a default? (YES/NO) >>> >>> Yes >>> >>>> [POLL] What do do with the default? >>>> >>>> 1.) Allow a default, and switch it to SAI (no configurables) >>>> 2.) Allow a default, and stay w/ the legacy 2i (no configurables) >>>> 3.) YAML config to override default index (legacy 2i remains the default) >>>> 4.) YAML config/guardrail to require index type selection (not required by >>>> default) >>> >>> 3.) YAML config to override default index (legacy 2i remains the default) >>> >>> >>> >>> On Mon, 15 May 2023 at 08:54, Mick Semb Wever <m...@apache.org >>> <mailto:m...@apache.org>> wrote: >>>> >>>> >>>>> [POLL] Centralize existing syntax or create new syntax? >>>>> >>>>> 1.) CREATE INDEX ... USING .... WITH OPTIONS... >>>>> 2.) CREATE LOCAL INDEX ... USING ... WITH OPTIONS... (same as 1, but >>>>> adds LOCAL keyword for clarity and separation from future GLOBAL indexes) >>>> >>>> >>>> (1) CREATE INDEX … >>>> >>>> >>>>> [POLL] Should there be a default? (YES/NO) >>>> >>>> >>>> Yes (but see below). >>>> >>>> >>>>> [POLL] What do do with the default? >>>>> >>>>> 1.) Allow a default, and switch it to SAI (no configurables) >>>>> 2.) Allow a default, and stay w/ the legacy 2i (no configurables) >>>>> 3.) YAML config to override default index (legacy 2i remains the default) >>>>> 4.) YAML config/guardrail to require index type selection (not required >>>>> by default) >>>> >>>> >>>> (4) YAML config. Commented out default of 2i. >>>> >>>> I agree that the default cannot change in 5.0, but our existing default of >>>> 2i can be commented out. >>>> >>>> For the user this gives them the same feedback, and puts the same >>>> requirement to edit one line of yaml, as when we disabled MVs and SASI in >>>> 4.0 >>>> No one has complained about either of these, which is a clear signal folk >>>> understood how to get their existing DDLs to work from 3.x to 4.x >>> >>> >>> -- >>> <https://www.datastax.com/> Mike Adamson >>> Engineering >>> >>> +1 650 389 6000 <tel:16503896000> | datastax.com <https://www.datastax.com/> >>> Find DataStax Online: >>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_datastax&d=DwMFaQ&c=adz96Xi0w1RHqtPMowiL2g&r=IFj3MdIKYLLXIUhYdUGB0cTzTlxyCb7_VUmICBaYilU&m=uHzE4WhPViSF0rsjSxKhfwGDU1Bo7USObSc_aIcgelo&s=akx0E6l2bnTjOvA-YxtonbW0M4b6bNg4nRwmcHNDo4Q&e=> >>> >>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.facebook.com_datastax&d=DwMFaQ&c=adz96Xi0w1RHqtPMowiL2g&r=IFj3MdIKYLLXIUhYdUGB0cTzTlxyCb7_VUmICBaYilU&m=uHzE4WhPViSF0rsjSxKhfwGDU1Bo7USObSc_aIcgelo&s=ncMlB41-6hHuqx-EhnM83-KVtjMegQ9c2l2zDzHAxiU&e=> >>> <https://twitter.com/DataStax> >>> <https://www.datastax.com/blog/rss.xml> <https://github.com/datastax> >>>
