You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Pengcheng Xiong (JIRA)" <ji...@apache.org> on 2016/10/19 22:23:58 UTC

[jira] [Created] (HIVE-15023) SimpleFetchOptimizer needs to optimize limit=0

Pengcheng Xiong created HIVE-15023:
--------------------------------------

             Summary: SimpleFetchOptimizer needs to optimize limit=0
                 Key: HIVE-15023
                 URL: https://issues.apache.org/jira/browse/HIVE-15023
             Project: Hive
          Issue Type: Sub-task
            Reporter: Pengcheng Xiong
            Assignee: Pengcheng Xiong


on current master
{code}
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)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)