Glenn Galvizo created ASTERIXDB-2832:
----------------------------------------
Summary: 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 Galvizo
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)
