[
https://issues.apache.org/jira/browse/HIVE-15023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15591142#comment-15591142
]
Jesus Camacho Rodriguez edited comment on HIVE-15023 at 10/20/16 8:13 AM:
--------------------------------------------------------------------------
I checked a bit further the code and I think the approach I propose above might
not be as simple as I thought, since we would need to create the task and thus
it is not simply moving the clause from one place to another...
Maybe another possible alternative is to set in SimpleFetchOptimizer:
{code}fetchWork.setSource(limit == 0 ? null : source);{code}
The advantage would be that we avoid the overhead of the task compiler till we
finally bail out in L200.
I think it is OK to proceed one way or another, but if we leave the fix as it
is now, please add a comment to the new _if_ statement in SimpleFetchOptimizer
explaining why we are bailing out there. Thanks
was (Author: jcamachorodriguez):
I checked a bit further the code and I think the approach I propose above might
not be as simple as I thought, since we would need to create the task and thus
it is not simply moving the clause from one place to another...
I think it is OK then to proceed, but if we leave the fix as it is now, please
add a comment to the new _if_ statement in SimpleFetchOptimizer explaining why
we are bailing out there. Thanks
> 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
> Attachments: HIVE-15023.01.patch
>
>
> 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)