impala-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jim Apple (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (IMPALA-5606) Wrong result order by same value column
Date Sat, 01 Jul 2017 22:09:05 GMT

     [ https://issues.apache.org/jira/browse/IMPALA-5606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jim Apple resolved IMPALA-5606.
-------------------------------
    Resolution: Not A Bug

Thank you for updating this ticket with your clarification. However, the behavior you see
is not a bug, but intentional.

> Wrong result order by same value column 
> ----------------------------------------
>
>                 Key: IMPALA-5606
>                 URL: https://issues.apache.org/jira/browse/IMPALA-5606
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 2.7.0
>         Environment: Linux 
>            Reporter: Fei, Zhang
>              Labels: correctness
>         Attachments: pic.png
>
>
> I want to do pagination with order by, limit, offset. But the return results is wrong
when the order by column has the same values. I attached the steps and result. Check the attachment
for more details.
> Add more description because someone misunderstood.
> I order by the result *_+only+_* with the column having the *_+same+_* values. *_+Not
include columns having different values+_*.
> The source in picture with below query:
> {code:java}
> SELECT id, date from xx ORDER BY date LIMIT 10 OFFSEST 0;
> {code}
> Then I got the top 10 rows from the table. 
> Next step, I want to paginate the result. The attachement content in the red and blue
rectangle are my attempts to paginate with different LIMIT parameter. 
> Take the red rectangle content as example,  I executed:
> {code:java}
> SELECT id from xx ORDER BY date LIMIT 1 OFFSET 0;
> {code}
> --->
> It should return the 1st row in the top 10 rows, but not; 
> Then
> {code:java}
> SELECT id from xx ORDER BY dae LIMIT 1 OFFSET 1;
> {code}
> --->
> It should return the second row in the top 10 rows, but not;
> The same wrong result for
> {code:java}
> SELECT id from xx ORDER BY date LIMIT 1 OFFSET 2;
> {code}
> --->
> It should return the third row in the top 10 rows, but not.
> you can see all above rows are the same for pagination with LIMIT and OFFSET. So I cannot
get the correct result for pagination



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message