You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Xiao Li (JIRA)" <ji...@apache.org> on 2018/09/18 15:44:00 UTC

[jira] [Created] (SPARK-25458) Support FOR ALL COLUMNS in ANALYZE TABLE

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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org