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

Lars Hofhansl commented on PHOENIX-5559:
----------------------------------------

Thanks! Putting a breakpoint in 
BaseScannerRegionObserver.throwIfScanOutOfRegion once with and once without the 
patch will show the problem.
The only difference is that different start row for the scan, where with this 
patch that start falls after any non-index key of for that region.


> With short index ids, index updates are written with the same index id in 
> 4.15.0
> --------------------------------------------------------------------------------
>
>                 Key: PHOENIX-5559
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5559
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.15.0, 5.1.0
>            Reporter: Lars Hofhansl
>            Assignee: Lars Hofhansl
>            Priority: Blocker
>             Fix For: 4.15.0, 5.1.0
>
>         Attachments: 5559-4.x-HBase-1.5.txt, 5559-4.x-HBase-1.5.txt, 
> 5559-test.txt
>
>
>  
> {code:java}
> phoenix: CREATE TABLE test (pk INTEGER PRIMARY KEY, v1 INTEGER, v2 integer);
> No rows affected (1.389 seconds)
> phoenix: create local index l1 on test(v1);
> 1 row affected (11.343 seconds)
> phoenix: create local index l2 on test(v1);
> 1 row affected (5.107 seconds)
> phoenix: UPSERT INTO test VALUES(2,2,2);
> 1 row affected (0.037 seconds)
> hbase: scan 'TEST'
> ROW                                     COLUMN+CELL                           
>                                                                             
>  \x00\x00\xC1\x03\x00\x80\x00\x00\x02   column=L#0:\x00\x00\x00\x00, 
> timestamp=1572842063925, value=x                                              
>        
>  \x80\x00\x00\x02                       column=0:\x00\x00\x00\x00, 
> timestamp=1572842063925, value=x                                              
>          
>  \x80\x00\x00\x02                       column=0:\x80\x0B, 
> timestamp=1572842063925, value=\x80\x00\x00\x02                               
>                  
>  \x80\x00\x00\x02                       column=0:\x80\x0C, 
> timestamp=1572842063925, value=\x80\x00\x00\x02                               
>                  
> 2 row(s) in 0.0190 seconds{code}
> There should be two index rows.
> And in fact there are with phoenix.index.longViewIndex.enabled set to true, 
> there are correctly two different index entries for both of the local indexes.
> [~gjacoby] [~rajeshbabu]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to