Index composite array fields

Description

 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

 

Components

Affects versions

Fix versions

Labels

Environment

None

Release Notes Description

None

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

Assignee

Reporter

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

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