Is the table salted? If the SALT_BUCKETS property was ever changed during the life of the table, this could lead to duplicates. You could get the same row key with a different salt byte. If not salted, are there any global, mutable secondary indexes. A number of issues have been fixed which will be in 4.12 release that lead to out-of-sync issues between the data and index table under high load (in particular when the same set of rows are frequently changing).
If you could file a JIRA with more information (Phoenix version, HBase version, DDL, indexes, etc), that'd be much appreciated. We can discuss more there. Thanks, James On Mon, Aug 28, 2017 at 9:34 AM, Kumar Palaniappan < kpalaniap...@marinsoftware.com> wrote: > For a weird reason, if we do scan on a table, with a non key, there are > duplicate rows in the table. > > If we do look up with the complete RK of a table, it doesnt show the > duplicates. > > What could be wrong? Appreciate your time. > > Similar as this one -https://issues.apache.org/jira/browse/PHOENIX-3755 > > > >
