[HIVE-21231] HiveJoinAddNotNullRule support for range predicates

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Labels: newbie pull-request-available
• Assignee: Miklos Gergely
• Reporter: Jesús Camacho Rodríguez
• Created: 07/Feb/19 21:41
• Updated: 27/Feb/24 22:13
• Resolved: 08/Apr/19 17:13

Description

For instance, given the following query:

SELECT t0.col0, t0.col1
FROM
  (
    SELECT col0, col1 FROM tab
  ) AS t0
  INNER JOIN
  (
    SELECT col0, col1 FROM tab
  ) AS t1
ON t0.col0 < t1.col0 AND t0.col1 > t1.col1

we could still infer that col0 and col1 cannot be null for any of the inputs. Currently we do not.

Issue Links

• is depended upon by: HIVE-21572 HiveRemoveSqCountCheck rule could be enhanced to capture more patterns
• links to: GitHub Pull Request #580