[SERVER-68743] Reenable pushing down into column scan stage of $type match expression Created: 11/Aug/22  Updated: 29/Oct/23  Resolved: 27/Oct/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 6.2.0-rc0

Type: Task Priority: Major - P3
Reporter: Irina Yatsenko (Inactive) Assignee: Irina Yatsenko (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-69105 Achieve column index performance acce... Closed
Issue split
split to SERVER-69916 Push {$exists: true} into column_scan... Closed
split to SERVER-70726 Support pushing down as per-path filt... Closed
split to SERVER-69610 Support $not in generatePerColumnFilt... Closed
split to SERVER-69885 Support $in in generatePerColumnFilte... Closed
split from SERVER-69916 Push {$exists: true} into column_scan... Closed
Backwards Compatibility: Fully Compatible
Participants:

 Description   

SERVER-68713 refactored translation of a few (easy to do) match expressions into EExpressions, but for columnstore indexes we'd like to also enable pushing down filters such as $in, $not, $type and $exists. After the translation is done will be able to re-enable splitting the corresponding predicates into per-path filters and pushing them down.

 

Also, the refactor from SERVER-68713 preserved the defensive wrappers, such as makeFillEmptyFalse, which are not needed when generating per-path filters in CSI. It would be nice to avoid injecting them.



 Comments   
Comment by Irina Yatsenko (Inactive) [ 27/Oct/22 ]

Implemented pushing down of $type and {$exists: true}

Comment by Githook User [ 27/Oct/22 ]

Author:

{'name': 'Irina Yatsenko', 'email': 'irina.yatsenko@mongodb.com', 'username': 'IrinaYatsenko'}

Message: SERVER-68743 Push down $exits and $type
Branch: master
https://github.com/mongodb/mongo/commit/c32ea289b77a3ec19651a0beb49d62275928355c

Comment by Justin Seyster [ 12/Sep/22 ]

I split $not into its own ticket to get this work started.

https://jira.mongodb.org/browse/SERVER-69610

Generated at Thu Feb 08 06:11:37 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.