[
https://issues.apache.org/jira/browse/PHOENIX-4419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16297753#comment-16297753
]
luanchangmiao commented on PHOENIX-4419:
----------------------------------------
Yes, it can be replicated.
The table structure is as below:
Hbase table structure:
hbase(main):003:0> describe 'TPTF.TEST_USER_TAG'Table TPTF.TEST_USER_TAG is
ENABLED
TPTF.TEST_USER_TAG, {TABLE_ATTRIBUTES => {coprocessor$1 =>
'|org.apache.phoenix.coprocessor.ScanRegionObserver|805306366|', coprocessor$2
=>
'|org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver|805306366|',
coprocessor$3 =>
'|org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver|805306366|',
coprocessor$4 =>
'|org.apache.phoenix.coprocessor.ServerCachingEndpointImpl|805306366|'}
COLUMN FAMILIES DESCRIPTION
{NAME => 'D',
DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0',
COMPRESSION => 'SNAPPY', VERSIONS => '1', TTL => 'FOREVER', MIN_VERSIONS =>
'0', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false',
BLOCKCACHE => 'true'}
{NAME => 'M', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW',
REPLICATION_SCOPE => '0', COMPRESSION => 'SNAPPY', VERSIONS => '1', TTL =>
'FOREVER', MIN_VERSIONS => '0', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE =>
'65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}
{NAME => 'W', DATA_BLOCK_ENCODING => 'NONE',
BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', COMPRESSION => 'SNAPPY',
VERSIONS => '1', TTL => 'FOREVER', MIN_VERSIONS => '0', KEEP_DELETED_CELLS =>
'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}
Phoenix view:
CREATE VIEW "TPTF.TEST_USER_TAG"( PK VARCHAR
PRIMARY KEY, "D"."PHONE_NO" VARCHAR, "D"."ACTION_DT"
VARCHAR, "D"."ACTION_DT_TILL_TD" VARCHAR,
"D"."REGISTER_DT" VARCHAR, "D"."REGISTER_DT_TILL_TD"
VARCHAR, "D"."SALE_FLAG" VARCHAR);
Thanks
> 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)
