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/10/02 15:56:01 UTC
[jira] [Updated] (SPARK-25458) Support FOR ALL COLUMNS in ANALYZE
TABLE
[ https://issues.apache.org/jira/browse/SPARK-25458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiao Li updated SPARK-25458:
----------------------------
Fix Version/s: (was: 2.5.0)
3.0.0
> 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
> Assignee: Dilip Biswal
> Priority: Major
> Fix For: 3.0.0
>
>
> 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