[PHOENIX-4419] The result of the query table row count by phoenix is not correct

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 4.6.0

Environment

The os version is : Red Hat Enterprise Linux Server release 7.3 (Maipo)
The hbase is : 1.1.1
The phoenix is 4.6.0

• Assignee: Unassigned
• Reporter: luanchangmiao
• Created: 30/Nov/17 01:51
• Updated: 03/Dec/20 03:57
• Resolved: 03/Dec/20 03:57

Description

Hi support,

When we use phoenix view to query table count, the result is as below:

Phoenix View：
select count(1) from "TESTTABLE";

1. 133702226

When we use RowCounter query table count, the result is as below:
HBase：
./hbase org.apache.hadoop.hbase.mapreduce.RowCounter 'TESTTABLE'

1. 132873423

The result of phoenix view is greater than RowCounter. Could you helo look into it?

Thanks
Jacky