[SPARK-34538] Hive Metastore support filter by not-in

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.0
• Component/s: SQL
• Assignee: XiDuo You
• Reporter: XiDuo You
• Created: 25/Feb/21 12:03
• Updated: 11/Mar/21 15:20
• Resolved: 11/Mar/21 15:20

Description

`NOT IN` is a useful condition to prune partition, it would be better to support it. Technically, we can convert `c not in(x,y)` to `c != x and c != y`, then push it to metastore.

Issue Links

• links to: [Github] Pull Request #31646 (ulysses-you)
• links to: [Github] Pull Request #31646 (ulysses-you)