Xiao Li created SPARK-25458:
-------------------------------
Summary: Support FOR ALL COLUMNS in ANALYZE TABLE
Key: SPARK-25458
URL: https://issues.apache.org/jira/browse/SPARK-25458
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 2.5.0
Reporter: Xiao Li
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.
{code:java}
ANALYZE TABLE [db_name.]tablename COMPUTE STATISTICS FOR ALL COLUMNS;
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
