You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "chenglei (JIRA)" <ji...@apache.org> on 2017/02/24 02:50:44 UTC

[jira] [Commented] (PHOENIX-3689) Not determinist order by with limit

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

chenglei commented on PHOENIX-3689:
-----------------------------------

Could you please provide your table DDL and some sample data? so we can reproduce and check if it is a bug.

> Not determinist order by with limit
> -----------------------------------
>
>                 Key: PHOENIX-3689
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3689
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.7.0
>            Reporter: Arthur
>
> The following request does not return the last value of myTable:
> select * from myTable order by myKey desc limit 1;
> Adding a 'group by myKey' clause gets back the good result.
> I noticed that an order by with 'limit 10' returns a merge of 10 results from each region and not 10 results of the whole request.
> So 'order by' is not determinist. It is a bug or a feature ?



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)