[jira] [Created] (ASTERIXDB-3536) Adding support for heterogeneous index

["shahrzad shirazi (Jira)" <ji...@apache.org>]

shahrzad shirazi created ASTERIXDB-3536:
-------------------------------------------

             Summary: 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


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)