[jira] [Comment Edited] (PHOENIX-1322) Add documentation for UPDATE STATISTICS command

["James Taylor (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-1322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14176593#comment-14176593 ] 

James Taylor edited comment on PHOENIX-1322 at 10/20/14 4:15 AM:
-----------------------------------------------------------------

Thanks for the patch, [~ramkrishna]. Here's some feedback:
Please put this as the first item in the recent.md list and add a "1." in front of it so it's rendered correctly:
+1. **[Collect Statistics](update_statistics.html)**. Collects the statistics for a table to improve query parallelization.** Available in our 3.2/4.2 release**

Slight tweak here so that language is consistent with other items, use link to new stats collection page, and correct typo:
+15. **[Cost-based Query Optimization]((https://issues.apache.org/jira/browse/PHOENIX-1177))**. With [statistics collection](update_statistics.md) in place, improve statistics collection to enable further query optimizations based on the size and cardinality of the data.

Surround names with <code> tag:
+For a given table named <code>my_table</code>:

For update_statistics.md, add a description at the end for phoenix.stats.updateFrequency:
4. phoenix.stats.updateFrequency
    * Minimum frequency in milliseconds that new statistics will be
checked for when pulling over new metadata from the client to the
server.






was (Author: jamestaylor):
Thanks for the patch, [~ramkrishna]. Here's some feedback:
Please put this as the first item in the recent.md list and add a "1." in front of it so it's rendered correctly:
+**[Collect Statistics](update_statistics.html)**. Collects the statistics for a table to improve query parallelization.** Available in our 3.2/4.2 release**

Slight tweak here so that language is consistent with other items, use link to new stats collection page, and correct typo:
+15. **[Cost-based Query Optimization]((https://issues.apache.org/jira/browse/PHOENIX-1177))**. With [statistics collection](update_statistics.md) in place, improve statistics collection to enable further query optimizations based on the size and cardinality of the data.

Surround names with <code> tag:
+For a given table named <code>my_table</code>:

For update_statistics.md, add a description at the end for phoenix.stats.updateFrequency:
4. phoenix.stats.updateFrequency
    * Minimum frequency in milliseconds that new statistics will be
checked for when pulling over new metadata from the client to the
server.





> Add documentation for UPDATE STATISTICS command
> -----------------------------------------------
>
>                 Key: PHOENIX-1322
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1322
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: James Taylor
>            Assignee: ramkrishna.s.vasudevan
>         Attachments: Phoenix-1322_1.patch
>
>
> Four places need to be updated:
> - Add a new webpage and add the webpage to the Using menu (/site/source/src/site/site.xml). The webpage can talk about the new ANALYZE <table> command and give a couple of examples. It'd be good to document that stats are updated automatically during splits and compaction. Also, mention the new property values you added to control - number of bytes before guidepost put in, min time before another analyze may be done. Don't talk about implementation, though, other than the "why" we're doing this (i.e. to improve parallelization).
> - Add the new ANALYZE call with a short explanation to ./phoenix-docs/src/docsrc/help/phoenix.csv. This will cause it to appear here: http://phoenix.apache.org/language/index.html
> - Add an item at the top for Statistics Collection with a short explanation here: site/source/src/site/markdown/recent.md
> - Remove the first item from Cost-based Query Optimization, or change the font to strike through with a note that it's implemented in 3.2/4.2) here: site/source/src/site/markdown/roadmap.md



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)