[
https://issues.apache.org/jira/browse/ASTERIXDB-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17396960#comment-17396960
]
ASF subversion and git services commented on ASTERIXDB-2791:
------------------------------------------------------------
Commit 931e738e89b8da86833df89ed3d453ae98c5fd32 in asterixdb's branch
refs/heads/master from Ali Alsuliman
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=931e738 ]
[ASTERIXDB-2791][IDX] Add option to exclude unknowns in secondary indexes
- user model changes: yes
- storage format changes: no
- interface changes: no
Details:
- add EXCLUDE UNKNOWN KEY and INCLUDE UNKNOWN KEY to CREATE INDEX statement
to allow user to exclude/include unknonwn keys.
- bring back the filter when creating the job spec for BTrees.
Use the filter when unknown keys should be excluded.
- For UPSERT, pass the filter for previous tuple, as well, to determine
if the previous tuple's index entry should be processed.
Change-Id: Id40de17d1392510f6ebfea5bd81037a9305895af
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/12624
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
Reviewed-by: Dmitry Lychagin <[email protected]>
> Enable storing nulls in secondary indexes
> -----------------------------------------
>
> Key: ASTERIXDB-2791
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2791
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: IDX - Indexes, STO - Storage
> Affects Versions: 0.9.5
> Reporter: Ali Alsuliman
> Assignee: Ali Alsuliman
> Priority: Major
> Fix For: 0.9.7
>
>
> Currently, nulls and missings keys are not stored in secondary indexes. This
> applies across all index types. It should be possible to accept nulls and
> missings keys (for example, to enable using secondary indexes for prefix
> searches)
> * Make sure array indexes handle NULLs/MISSINGs
> * Make sure inverted indexes handle NULLs/MISSINGs
> * Make sure R-Tree indexes handle NULLs/MISSINGs
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
