Author: ssa Date: Wed Jul 11 21:00:47 2018 New Revision: 1835673 URL: http://svn.apache.org/viewvc?rev=1835673&view=rev Log: Updated statistics page for the known issue
Modified: phoenix/site/publish/update_statistics.html phoenix/site/source/src/site/markdown/update_statistics.md Modified: phoenix/site/publish/update_statistics.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/update_statistics.html?rev=1835673&r1=1835672&r2=1835673&view=diff ============================================================================== --- phoenix/site/publish/update_statistics.html (original) +++ phoenix/site/publish/update_statistics.html Wed Jul 11 21:00:47 2018 @@ -1,7 +1,7 @@ <!DOCTYPE html> <!-- - Generated by Apache Maven Doxia at 2018-06-10 + Generated by Apache Maven Doxia at 2018-07-11 Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> @@ -206,6 +206,13 @@ </div> </div> <div class="section"> + <h2 id="Known_issues">Known issues</h2> + <ul> + <li><tt><b>Duplicated records</b> (SQL count shows more rows than HBase row_count) for Phoenix versions earlier than <b>4.12</b> </tt></li> + </ul> + <p>May happen for tables with several regions where guide posts were not generated for last region(s) because the region size is smaller than the guide post width. In that case, the parallel scans for those regions would start with the latest guide post instead of startkey of this region. <b>Fixed in 4.12</b> as part of <a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-4007">PHOENIX-4007</a> </p> +</div> +<div class="section"> <h2 id="Configuration">Configuration</h2> <p>The configuration parameters controlling statistics collection include:</p> <ol style="list-style-type: decimal"> Modified: phoenix/site/source/src/site/markdown/update_statistics.md URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/update_statistics.md?rev=1835673&r1=1835672&r2=1835673&view=diff ============================================================================== --- phoenix/site/source/src/site/markdown/update_statistics.md (original) +++ phoenix/site/source/src/site/markdown/update_statistics.md Wed Jul 11 21:00:47 2018 @@ -53,6 +53,14 @@ To remove the guidepost width, set the p ALTER TABLE my_table SET GUIDE_POSTS_WIDTH = null +##Known issues + +* <code>**Duplicated records** (SQL count shows more rows than HBase row_count) for Phoenix versions earlier than **4.12** </code> + +May happen for tables with several regions where guide posts were not generated for last region(s) because the region size is smaller than the guide post width. +In that case, the parallel scans for those regions would start with the latest guide post instead of startkey of this region. +**Fixed in 4.12** as part of [PHOENIX-4007](https://issues.apache.org/jira/browse/PHOENIX-4007) + ## Configuration The configuration parameters controlling statistics collection include: