asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Glenn Justo Galvizo (Jira)" <j...@apache.org>
Subject [jira] [Assigned] (ASTERIXDB-2832) Enumerate Additional Approaches to Specify Empty Arrays for Array Index Optimization
Date Fri, 25 Jun 2021 22:18:00 GMT

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Glenn Justo Galvizo reassigned ASTERIXDB-2832:
----------------------------------------------

    Assignee: Glenn Justo Galvizo

> Enumerate Additional Approaches to Specify Empty Arrays for Array Index Optimization
> ------------------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-2832
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2832
>             Project: Apache AsterixDB
>          Issue Type: Improvement
>            Reporter: Glenn Justo Galvizo
>            Assignee: Glenn Justo Galvizo
>            Priority: Major
>
> To use array indexes for universal quantification queries, the query must also indicate
the array is non-empty. If this is not true, then we cannot use the index because array indexes
do not store empty arrays. 
>  
> Currently, the use must specify this clause by using the LEN function on the array and
enforcing that this is greater than 0 (e.g. LEN(myarray) > 0 AND ...). But this is not
the only way to specify that an array is empty. A user could also:
>  # Index an element of the array, with the expectation this element is not null.
>  # Use an existential clause on that same array.
>  # Use some clause with an array function, where the result of this comparison is not
null.
>  # ...
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message