[
https://issues.apache.org/jira/browse/ASTERIXDB-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
shahrzad shirazi updated ASTERIXDB-3536:
----------------------------------------
Description:
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}
was:
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}
> 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)
