Sokolov Yura created PHOENIX-4642: ------------------------------------- Summary: 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
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)