[
https://issues.apache.org/jira/browse/ASTERIXDB-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17906411#comment-17906411
]
ASF subversion and git services commented on ASTERIXDB-3536:
------------------------------------------------------------
Commit 993f91c7504451c844b9d6d16777bbb5add71952 in asterixdb's branch
refs/heads/master from Shahrzad shirazi
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=993f91c750 ]
[ASTERIXDB-3536][IDX] Add support for heterogeneous index
- user model changes: no
- storage format changes: no
- interface changes: no
details:
Introducing the heterogeneous index which allows creating an
index on a field without specifying its type. This means the
field’s type no longer needs to be defined in the data type
or the index creation DDL.
Ext-ref: MB-27845
Change-Id: I03b5edfbc304cdb9f36e2b382050781811a14759
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18522
Reviewed-by: Ali Alsuliman <[email protected]>
Tested-by: Ali Alsuliman <[email protected]>
> Adding support for heterogeneous index
> --------------------------------------
>
> Key: ASTERIXDB-3536
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3536
> Project: Apache AsterixDB
> Issue Type: Improvement
> Components: COMP - Compiler
> Reporter: shahrzad shirazi
> Priority: Minor
>
> A Heterogeneous Index allows creating an index on a field without specifying
> its type. This means the field’s type no longer needs to be defined in the
> data type or the index creation DDL.
> Previously, creating a secondary index required the field's type to be
> defined either in the data type or explicitly in the index DDL, making it
> impossible to index heterogeneous fields.
>
> example:
> {code:java}
> CREATE TYPE UserType AS { userId : int};
> CREATE DATASET UserTypes(UserType) primary key userId;
> // Creating a heterogeneous index on the field age
> CREATE Index idx_user_age on UserTypes(age);{code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
