dilipbiswal commented on a change in pull request #25524:
[SPARK-28788][DOC][SQL]Document ANALYZE TABLE statement in SQL Reference
URL: https://github.com/apache/spark/pull/25524#discussion_r320343508
##########
File path: docs/sql-ref-syntax-aux-analyze-table.md
##########
@@ -19,4 +19,71 @@ license: |
limitations under the License.
---
-**This page is under construction**
+### Description
+
+The `ANALYZE TABLE` statement collects statistics about the table to be used
by the query optimizer to find a better query execution plan.
+
+### Syntax
+{% highlight sql %}
+ANALYZE TABLE table_name [ PARTITION ( partition_col_name [ =
partition_col_val ] [ , ... ] ) ]
+ COMPUTE STATISTICS [ NOSCAN | FOR COLUMNS col [ , ... ] | FOR ALL COLUMNS ]
+
+{% endhighlight %}
+
+### Parameters
+<dl>
+ <dt><code><em>table_name</em></code></dt>
+ <dd>The name of an existing table.</dd>
+</dl>
+
+<dl>
+ <dt><code><em>PARTITION ( partition_col_name [ = partition_col_val ] [ , ...
] )</em></code></dt>
+ <dd>Specifies one or more partition column and value pairs. The partition
value is optional.</dd>
+</dl>
+
+<dl>
+ <dt><code><em>[ NOSCAN | FOR COLUMNS col [ , ... ] | FOR ALL COLUMNS
]</em></code></dt>
+ <dd>
+ <ul>
+ <li> If no analyze option is specified, <code>ANALYZE TABLE</code>
collects the table's number of rows and size in bytes. </li>
+ <li> NOSCAN
Review comment:
@huaxingao will it read better if we bold this ?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
