Hi all, we are having some troubles with Phoenix 4.14 on top of Hbase 1.2, because some select are returning duplicate rows with the same private. In our application, we make several upsert of rows with the same key since we have to keep synchronized an oracle and a phoenix table.
We started to notice this problem after the update of phoenix to version 4.14 from version 4.7 and hbase from version 1.1 to version 1.2. I suspect this issue could be somehow related to returning different versions of the same hbase row as different rows. In order to look into this issue, my idea was to perform some scan directly on hbase, but i noticed that some bytes are appended after the first field of the PK and i'm not able to produce the equivalent scan of my select. Finally my question are: Is there a way to use the phoenix library to produce the equivalent bytes of my query to use in the Hbase Shell? Could this issues be related to the update of phoenix, since the data were written using phoenix 4.7 and now we are reading them from a phoenix 4.14 server ? Any hint will be appreciated. Thanks [image: image.png]
