drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5051) Returning incorrect number of rows while querying using both nested select and offset
Date Fri, 18 Nov 2016 12:24:58 GMT

    [ https://issues.apache.org/jira/browse/DRILL-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15676604#comment-15676604
] 

ASF GitHub Bot commented on DRILL-5051:
---------------------------------------

GitHub user zbdzzg opened a pull request:

    https://github.com/apache/drill/pull/658

    DRILL-5051: Fix incorrect result returned in nest query with offset specified

    1. Fix this problem.
    2. Merge two limit methods, most of code is the same.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/zbdzzg/drill master

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/drill/pull/658.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #658
    
----
commit 982b8c2bfa742feffb551ba5bfb66ba01b38d839
Author: hongze.zhz <hongze.zhz@alibaba-inc.com>
Date:   2016-11-18T12:11:38Z

    DRILL-5051: Fix incorrect result returned in nest query with offset specified

----


> Returning incorrect number of rows while querying using both nested select and offset
> -------------------------------------------------------------------------------------
>
>                 Key: DRILL-5051
>                 URL: https://issues.apache.org/jira/browse/DRILL-5051
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 1.8.0
>         Environment: Fedora 24 / OpenJDK 8
>            Reporter: Hongze Zhang
>             Fix For: Future
>
>
> My SQl:
> select count(1) from (select id from (select id from cp.`tpch/lineitem.parquet` LIMIT
2) limit 1 offset 1) 
> This SQL returns nothing.
> Something goes wrong in LimitRecordBatch.java, and the reason is different with [DRILL-4884|https://issues.apache.org/jira/browse/DRILL-4884?filter=-2]



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

Mime
View raw message