Michael J. Carey created ASTERIXDB-2914:
-------------------------------------------
Summary: Need to see through object_remove / object_remove_fields
functions
Key: ASTERIXDB-2914
URL: https://issues.apache.org/jira/browse/ASTERIXDB-2914
Project: Apache AsterixDB
Issue Type: Improvement
Reporter: Michael J. Carey
Consider the following sequence of steps using the Don C book data:
_USE DonCData;_
_CREATE INDEX custidx ON orders(custid: string);_
_WITH orders2 AS (SELECT VALUE object_remove(o, 'ship_date') FROM orders o)_
_SELECT VALUE o2 FROM orders2 o2 WHERE o2.custid = 'C41';_
The query fails to use the index because it doesn't understand object_remove.
The optimizer needs to understand the input/output types and properties
associated with the field removal functions - as a prerequisite to efficiently
supporting negative projections like MongoDB and some other systems do.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
