Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
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.
Attachments
Attachments
Issue Links
- is depended upon by
-
HIVE-21572 HiveRemoveSqCountCheck rule could be enhanced to capture more patterns
- Open
- links to