GitHub user dilipbiswal opened a pull request:
https://github.com/apache/spark/pull/22566
[SPARK-25458][SQL] Support FOR ALL COLUMNS in ANALYZE TABLE
## What changes were proposed in this pull request?
**Description from the JIRA :**
Currently, to collect the statistics of all the columns, users need to
specify the names of all the columns when calling the command "ANALYZE TABLE
... FOR COLUMNS...". This is not user friendly. Instead, we can introduce the
following SQL command to achieve it without specifying the column names.
```
ANALYZE TABLE [db_name.]tablename COMPUTE STATISTICS FOR ALL COLUMNS;
```
## How was this patch tested?
Added new tests in SparkSqlParserSuite and StatisticsSuite
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/dilipbiswal/spark SPARK-25458
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/spark/pull/22566.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #22566
----
commit d0da8bd88c351f3b679f539ae2e59bda8e6cbe71
Author: Dilip Biswal <dbiswal@...>
Date: 2018-09-19T04:07:40Z
[SPARK-25458] Support FOR ALL COLUMNS in ANALYZE TABLE
----
---
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
