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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 10/Jul/17 06:41
• Updated: 23/May/18 00:00
• Resolved: 12/Jul/17 18:15

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

Issue Links

• links to: ReviewBoard