Hanifi Gunes created DRILL-1590:
-----------------------------------

             Summary: Invalid result returned for queries that has count with 
limit
                 Key: DRILL-1590
                 URL: https://issues.apache.org/jira/browse/DRILL-1590
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Hanifi Gunes


The following query

{code:sql}
select count(*) from  dfs.`local`.`yelp_academic_dataset_business.json` limit 1
{code}

returns
{panel}
844
{panel}

And this one down here
{code:sql}
select count(*) from  dfs.`local`.`yelp_academic_dataset_business.json` limit 2
{code}

returns 
{panel}
838
844
844
{panel}

Initial impression is that limit seems to work on batches rather than 
individual records. 

ps: I had to test this on a detached head. We need to verify this on 0.7



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

Reply via email to