Index composite array fields
Description
Components
Affects versions
Fix versions
Labels
Environment
None
Release Notes Description
None
depends on
Activity
Show:
Ajay Pal Bhullar January 27, 2022 at 4:40 PM
verified via automation for flatten_keys in 7.1.0-2123
Ajay Pal Bhullar January 24, 2022 at 11:49 PM
can i close this improvement based on my flatten keys testing and automation?
CB robot September 29, 2021 at 1:47 AM
Build couchbase-server-7.1.0-1376 contains query-ee commit 41fbec0 with commit message:
. Advise FLATTENKEYS() for UNNEST
CB robot September 29, 2021 at 1:47 AM
Build couchbase-server-7.1.0-1376 contains query commit 26bd6c1 with commit message:
. Advise FLATTENKEYS() for UNNEST
CB robot September 25, 2021 at 1:26 AM
Build couchbase-server-7.1.0-1356 contains query commit be6ba32 with commit message:
. Allow Flattenkeys() in Update Stats
Fixed
Pinned fields
Click on the next to a field label to start pinning.
Details
Details
Assignee
Ajay Pal Bhullar
Ajay Pal BhullarReporter
Sitaram Vemulapalli
Sitaram VemulapalliPriority
Instabug
Open Instabug
PagerDuty
PagerDuty Incident
PagerDuty

PagerDuty Incident
Sentry
Linked Issues
Sentry
Linked Issues
Zendesk Support
Linked Tickets
Zendesk Support

Linked Tickets
Created January 4, 2019 at 11:21 PM
Updated June 23, 2023 at 2:10 PM
Resolved October 4, 2021 at 11:40 PM
Instabug
https://docs.google.com/document/d/1_L3zu7ro5koFkeEHtAr5f9fReuZfNd7QlmOj8x0yidg/edit
ID
Requirement
Comments
Introduce new modifier for Array Index key. (
or UNWIND or UNNEST). Mark it is reserved keyword.
Indexer needs to detect this modifier and flatten the array and shift the index keys while indexing
The positions of index keys will be shifted accordingly (in the spans/group/aggregates)
Sargable the index based on the individual flatten keys
Generate spans based on individual flatten keys
Support for both DISTINCT ALL, ALL modifiers
UnnestScan should support new index keys.
UNNEST and non-unnest IndexScan combine and do index Selection to avoid IntersectScan