phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joseph Sun (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-2769) Order by desc return wrong results
Date Tue, 15 Mar 2016 06:55:33 GMT
Joseph Sun created PHOENIX-2769:
-----------------------------------

             Summary: Order by desc return wrong results
                 Key: PHOENIX-2769
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2769
             Project: Phoenix
          Issue Type: Bug
            Reporter: Joseph Sun


create table access_logs (
	event_time date not null,
	uuid varchar(36) not null,
	event_type varchar(32),
	CONSTRAINT pk PRIMARY KEY (event_time,uuid)
) VERSIONS=1,SALT_BUCKETS=6,IMMUTABLE_ROWS=true;


I insert 2,000,000 records to access_logs ,and event_time between 2016-01-06  to 2016-03-15
.

I execute SQL. 

>select event_time from access_logs  order by event_time asc limit 10;
+--------------------------+
|        EVENT_TIME        |
+--------------------------+
| 2016-01-06 18:41:54.000  |
| 2016-01-06 19:56:46.000  |
| 2016-01-06 20:25:12.000  |
| 2016-01-06 20:41:37.000  |
| 2016-01-06 20:46:20.000  |
| 2016-01-06 20:53:10.000  |
| 2016-01-06 21:04:09.000  |
| 2016-01-07 01:22:57.000  |
| 2016-01-07 10:59:11.000  |
| 2016-01-07 12:52:56.000  |
+--------------------------+
 
> select event_time from access_logs order by event_time desc limit 10;
+--------------------------+
|        EVENT_TIME        |
+--------------------------+
| 2016-02-11 13:07:25.000  |
| 2016-02-11 13:07:24.000  |
| 2016-02-11 13:07:24.000  |
| 2016-02-11 13:07:23.000  |
| 2016-02-11 13:07:23.000  |
| 2016-02-11 13:07:22.000  |
| 2016-02-11 13:07:21.000  |
| 2016-02-11 13:07:21.000  |
| 2016-02-11 13:07:20.000  |
| 2016-02-11 13:07:20.000  |

> select event_time from access_logs where event_time>to_date('2016-02-11 13:07:25')
order by event_time desc limit 10;
+--------------------------+
|        EVENT_TIME        |
+--------------------------+
| 2016-02-25 18:34:17.000  |
| 2016-02-25 18:34:17.000  |
| 2016-02-25 18:34:16.000  |
| 2016-02-25 18:34:16.000  |
| 2016-02-25 18:34:15.000  |
| 2016-02-25 18:34:15.000  |
| 2016-02-25 18:34:14.000  |
| 2016-02-25 18:34:14.000  |
| 2016-02-25 18:34:14.000  |
| 2016-02-25 18:34:14.000  |
+--------------------------+


Check the return results ,the 'order by event_time desc' is not return correct results.



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

Mime
View raw message