You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Arthur (JIRA)" <ji...@apache.org> on 2017/02/23 17:29:44 UTC
[jira] [Created] (PHOENIX-3689) Not determinist order by with limit
Arthur created PHOENIX-3689:
-------------------------------
Summary: 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)