[ https://issues.apache.org/jira/browse/ASTERIXDB-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael J. Carey updated ASTERIXDB-2914: ---------------------------------------- Fix Version/s: 0.9.8 > 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 > Assignee: Dmitry Lychagin > Priority: Major > Fix For: 0.9.8 > > > 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.20.1#820001)