You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Glenn Justo Galvizo (Jira)" <ji...@apache.org> on 2021/07/14 00:21:00 UTC
[jira] [Resolved] (ASTERIXDB-2832) Enumerate Additional Approaches
to Specify Empty Arrays for Array Index Optimization
[ https://issues.apache.org/jira/browse/ASTERIXDB-2832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Glenn Justo Galvizo resolved ASTERIXDB-2832.
--------------------------------------------
Resolution: Won't Do
We can now focus on a single pattern (instead of trying to infer multiple).
> 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)