[
https://issues.apache.org/jira/browse/PHOENIX-2769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15198758#comment-15198758
]
Joseph Sun edited comment on PHOENIX-2769 at 3/17/16 5:17 AM:
--------------------------------------------------------------
I execute some sql ,the problem is reproduced.
{code}
> select count(0) from access_logs;
+-----------+
| COUNT(0) |
+-----------+
| 1458242 |
+-----------+
> explain select * from access_logs order by event_time desc limit 10;
+-----------------------------------------------------------------+
| PLAN |
+-----------------------------------------------------------------+
| CLIENT 6-CHUNK SERIAL 6-WAY REVERSE FULL SCAN OVER ACCESS_LOGS |
| SERVER 10 ROW LIMIT |
| CLIENT MERGE SORT |
| CLIENT 10 ROW LIMIT |
+-----------------------------------------------------------------+
> UPDATE STATISTICS access_logs;
No rows affected (6.634 seconds)
> explain select * from access_logs order by event_time desc limit 10;
+-----------------------------------------------------------------+
| PLAN |
+-----------------------------------------------------------------+
| CLIENT 6-CHUNK SERIAL 6-WAY REVERSE FULL SCAN OVER ACCESS_LOGS |
| SERVER 10 ROW LIMIT |
| CLIENT MERGE SORT |
| CLIENT 10 ROW LIMIT |
+-----------------------------------------------------------------+
> execute some sql
> explain select * from access_logs order by event_time desc limit 10;
+------------------------------------------------------------------------------------------------+
| PLAN
|
+------------------------------------------------------------------------------------------------+
| CLIENT 24-CHUNK 1408646 ROWS 5662311262 BYTES SERIAL 6-WAY REVERSE FULL SCAN
OVER ACCESS_LOGS |
| SERVER 10 ROW LIMIT
|
| CLIENT MERGE SORT
|
| CLIENT 10 ROW LIMIT
|
+------------------------------------------------------------------------------------------------+
> select * from access_logs order by event_time desc limit 10;
now the wrong results is return.
{code}
was (Author: ryvius):
I execute some sql ,the problem is reproduced.
{quote}
> select count(0) from access_logs;
+-----------+
| COUNT(0) |
+-----------+
| 1458242 |
+-----------+
> explain select * from access_logs order by event_time desc limit 10;
+-----------------------------------------------------------------+
| PLAN |
+-----------------------------------------------------------------+
| CLIENT 6-CHUNK SERIAL 6-WAY REVERSE FULL SCAN OVER ACCESS_LOGS |
| SERVER 10 ROW LIMIT |
| CLIENT MERGE SORT |
| CLIENT 10 ROW LIMIT |
+-----------------------------------------------------------------+
> UPDATE STATISTICS access_logs;
No rows affected (6.634 seconds)
> explain select * from access_logs order by event_time desc limit 10;
+-----------------------------------------------------------------+
| PLAN |
+-----------------------------------------------------------------+
| CLIENT 6-CHUNK SERIAL 6-WAY REVERSE FULL SCAN OVER ACCESS_LOGS |
| SERVER 10 ROW LIMIT |
| CLIENT MERGE SORT |
| CLIENT 10 ROW LIMIT |
+-----------------------------------------------------------------+
> execute some sql
> explain select * from access_logs order by event_time desc limit 10;
+------------------------------------------------------------------------------------------------+
| PLAN
|
+------------------------------------------------------------------------------------------------+
| CLIENT 24-CHUNK 1408646 ROWS 5662311262 BYTES SERIAL 6-WAY REVERSE FULL SCAN
OVER ACCESS_LOGS |
| SERVER 10 ROW LIMIT
|
| CLIENT MERGE SORT
|
| CLIENT 10 ROW LIMIT
|
+------------------------------------------------------------------------------------------------+
> select * from access_logs order by event_time desc limit 10;
now the wrong results is return.
{quote}
> Order by desc return wrong results
> ----------------------------------
>
> Key: PHOENIX-2769
> URL: https://issues.apache.org/jira/browse/PHOENIX-2769
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.6.0, 4.7.0
> Environment: 3 centos servers
> Reporter: Joseph Sun
> Labels: test
>
> 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)
