[HIVE-15023] SimpleFetchOptimizer needs to optimize limit=0

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.3.0
• Assignee: Pengcheng Xiong
• Reporter: Pengcheng Xiong
• Created: 19/Oct/16 22:23
• Updated: 27/Feb/24 22:23
• Resolved: 08/Nov/16 22:58

Description

on current master

hive> explain select key from src limit 0;
OK
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0
    Fetch Operator
      limit: 0
      Processor Tree:
        TableScan
          alias: src
          Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
          Select Operator
            expressions: key (type: string)
            outputColumnNames: _col0
            Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
            Limit
              Number of rows: 0
              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
              ListSink

Time taken: 7.534 seconds, Fetched: 20 row(s)

Issue Links

• is related to: HIVE-14866 Remove logic to set global limit from SemanticAnalyzer