[HIVE-24209] Incorrect search argument conversion for NOT BETWEEN operation when vectorization is enabled

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Vectorization
• Labels: pull-request-available
• Assignee: Ganesha Shreedhara
• Reporter: Ganesha Shreedhara
• Created: 29/Sep/20 13:20
• Updated: 17/Nov/22 08:47
• Resolved: 06/Oct/20 04:40

Description

We skipped adding GenericUDFOPNot UDF in filter expression for NOT BETWEEN operation when vectorization is enabled because of the improvement done as part of HIVE-15884. But, this is not handled during the conversion of filter expression to search argument due to which incorrect predicate gets pushed down to storage layer that leads to incorrect splits generation and incorrect result. 

Issue Links

• is caused by: HIVE-15884 Optimize not between for vectorization
• links to: GitHub Pull Request #1535