[SPARK-25458] Support FOR ALL COLUMNS in ANALYZE TABLE

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Dilip Biswal
• Reporter: Xiao Li
• Created: 18/Sep/18 15:43
• Updated: 03/Oct/18 11:30
• Resolved: 28/Sep/18 22:03

Description

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;

Issue Links

• links to: [Github] Pull Request #22566 (dilipbiswal)
• links to: [Github] Pull Request #22566 (dilipbiswal)