phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4642) Select from local index in backward direction returns only from last region.
Date Wed, 07 Mar 2018 22:32:00 GMT

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

James Taylor commented on PHOENIX-4642:
---------------------------------------

[~chrajeshbabu32@gmail.com] - WDYT? Will this have been fixed in 4.13?

> Select from local index in backward direction returns only from last region.
> ----------------------------------------------------------------------------
>
>                 Key: PHOENIX-4642
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4642
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.11.0
>         Environment: Amazon EMR HBase 1.3 Phoenix 4.11 .
>            Reporter: Sokolov Yura
>            Priority: Major
>
> I have a table:
> {code}
> CREATE TABLE IF NOT EXISTS PRODUCT_HISTORY_2 (                                      
                                                                                         
                                                        
>     ts BIGINT NOT NULL,                                                             
                                   
>     id VARCHAR NOT NULL,                                                            
                                   
>     merchantId VARCHAR,                                                             
                                   
>     storeId VARCHAR,                                                                
                                   
>     a.product VARCHAR,                                                              
                                   
>     CONSTRAINT pk PRIMARY KEY(ts, id)                                               
                                   
> ) COMPRESSION=GZ,VERSIONS=2,UPDATE_CACHE_FREQUENCY=1000,APPEND_ONLY_SCHEMA=true,IMMUTABLE_ROWS=true;
                   
>                                                                                     
                                   
> CREATE LOCAL INDEX IF NOT EXISTS PRODUCT_HISTORY_2_ID_TS ON PRODUCT_HISTORY_2 (     
                                   
>     id, ts                                                                          
                                   
> ) COMPRESSION=GZ;
> {code}
> It is large enough to be splitted into 16 regions.
> Now I want to select alll items by id:
> {code}
> 0: jdbc:phoenix:localhost:2181:/hbase> select id, ts from product_history_2 where
id = '1491199695565244581-139-1-582-3894176988' order by ts;
> +-------------------------------------------+----------------+
> |                    ID                     |       TS       |
> +-------------------------------------------+----------------+
> | 1491199695565244581-139-1-582-3894176988  | 1498709133486  |
> | 1491199695565244581-139-1-582-3894176988  | 1498810584706  |
> | 1491199695565244581-139-1-582-3894176988  | 1499083503309  |
> | 1491199695565244581-139-1-582-3894176988  | 1499170817262  |
> | 1491199695565244581-139-1-582-3894176988  | 1503663938614  |
> | 1491199695565244581-139-1-582-3894176988  | 1506596564228  |
> | 1491199695565244581-139-1-582-3894176988  | 1509714911254  |
> | 1491199695565244581-139-1-582-3894176988  | 1517514069109  |
> +-------------------------------------------+----------------+
> 8 rows selected (0,107 seconds)
> {code}
> And now I want to fetch same rows, but with time descending:
> {code}
> 0: jdbc:phoenix:localhost:2181:/hbase> select id, ts from product_history_2 where
id = '1491199695565244581-139-1-582-3894176988' order by ts desc;
> +-------------------------------------------+----------------+
> |                    ID                     |       TS       |
> +-------------------------------------------+----------------+
> | 1491199695565244581-139-1-582-3894176988  | 1517514069109  |
> | 1491199695565244581-139-1-582-3894176988  | 1509714911254  |
> +-------------------------------------------+----------------+
> 2 rows selected (0,048 seconds)
> {code}
> Ooops, where are other 6 rows?
> Both queries uses local index:
> {code}
> 0: jdbc:phoenix:localhost:2181:/hbase> explain select id, ts from product_history_2
where id = '1491199695565244581-139-1-582-3894176988' order by ts;
> +--------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
> |                                                                       PLAN        
                                                              | EST_BYTES_READ  | EST_ROWS_READ
 |
> +--------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
> | CLIENT 14-CHUNK 34026740 ROWS 4089447171 BYTES PARALLEL 14-WAY RANGE SCAN OVER PRODUCT_HISTORY_2
[1,'1491199695565244581-139-1-582-3894176988']  | null            | null           |
> |     SERVER FILTER BY FIRST KEY ONLY                                               
                                                              | null            | null   
       |
> | CLIENT MERGE SORT                                                                 
                                                              | null            | null   
       |
> +--------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
> 3 rows selected (0,024 seconds)
> 0: jdbc:phoenix:localhost:2181:/hbase> explain select id, ts from product_history_2
where id = '1491199695565244581-139-1-582-3894176988' order by ts desc;
> +----------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
> |                                                                           PLAN    
                                                                      | EST_BYTES_READ  |
EST_ROWS_READ  |
> +----------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
> | CLIENT 14-CHUNK 34026740 ROWS 4089447171 BYTES PARALLEL 14-WAY REVERSE RANGE SCAN OVER
PRODUCT_HISTORY_2 [1,'1491199695565244581-139-1-582-3894176988']  | null            | null
          |
> |     SERVER FILTER BY FIRST KEY ONLY                                               
                                                                      | null            |
null           |
> | CLIENT MERGE SORT                                                                 
                                                                      | null            |
null           |
> +----------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+----------------+
> 3 rows selected (0,018 seconds)
> {code}
> Possibly related bugs are : PHOENIX-3898 and PHOENIX-4292
> Unfortunately I can no test phoenix 4.13 yet.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message