[HIVE-17066] Query78 filter wrong estimatation is generating bad plan - ASF JIRA

Log work

Agile Board

Rank to Top

Rank to Bottom

Bulk Copy Attachments

Bulk Move Attachments

Voters

Watch issue

Watchers

Create sub-task

Convert to sub-task

Move

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 3.0.0
Component/s: None
Labels:
None

Description

Filter operator is estimating 1 row following a left outer join causing bad estimates

Reducer 12 
            Execution mode: vectorized, llap
            Reduce Operator Tree:
              Map Join Operator
                condition map:
                     Left Outer Join0 to 1
                keys:
                  0 KEY.reducesinkkey0 (type: bigint), KEY.reducesinkkey1 (type: bigint)
                  1 KEY.reducesinkkey0 (type: bigint), KEY.reducesinkkey1 (type: bigint)
                outputColumnNames: _col0, _col1, _col3, _col4, _col5, _col6, _col8
                input vertices:
                  1 Map 14
                Statistics: Num rows: 71676270660 Data size: 3727166074320 Basic stats: COMPLETE Column stats: COMPLETE
                Filter Operator
                  predicate: _col8 is null (type: boolean)
                  Statistics: Num rows: 1 Data size: 52 Basic stats: COMPLETE Column stats: COMPLETE
                  Select Operator
                    expressions: _col0 (type: bigint), _col1 (type: bigint), _col3 (type: int), _col4 (type: double), _col5 (type: double), _col6 (type: bigint)
                    outputColumnNames: _col0, _col1, _col3, _col4, _col5, _col6
                    Statistics: Num rows: 1 Data size: 52 Basic stats: COMPLETE Column stats: COMPLETE