You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "luanchangmiao (JIRA)" <ji...@apache.org> on 2017/11/30 01:52:00 UTC

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

luanchangmiao created PHOENIX-4419:
--------------------------------------

             Summary: The result of the query table row count  by phoenix is not correct
                 Key: PHOENIX-4419
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4419
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 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

            Reporter: luanchangmiao


Hi support,

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

Phoenix View:
select count(1) from "TESTTABLE";
# 133702226

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

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

Thanks
Jacky



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)