Ankit Singhal created PHOENIX-2683:
--------------------------------------
Summary: store rowCount and byteCount at guidePost level
Key: PHOENIX-2683
URL: https://issues.apache.org/jira/browse/PHOENIX-2683
Project: Phoenix
Issue Type: Bug
Reporter: Ankit Singhal
Assignee: Ankit Singhal
Priority: Minor
The GUIDE_POSTS_WIDTH and GUIDE_POSTS_ROW_COUNT should contain the number
of bytes and number of rows which were traversed since the last guidepost.
So given some start key and stop key from a scan and knowledge that a given
column family is used in a query, you should be able to run a query like
this:
SELECT SUM(GUIDE_POSTS_WIDTH) bytes_traversed,
SUM(GUIDE_POSTS_ROW_COUNT) rows_traversed
FROM SYSTEM.STATS
WHERE COLUMN_FAMILY = :1
AND GUIDE_POST_KEY >= :2
AND GUIDE_POST_KEY < :3
where :1 is the column family, :2 is the start row of the scan, and :3 is
the stop row of the scan. The result of the query should tell you the
bytes_traversed and the rows_traversed with a granularity of the
phoenix.stats.guidepost.width config parameter.
Description is copied from dev mail thread.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
