Versions Compared

Old Version 25

changes.mady.by.user Chaoyu Tang

Saved on

compared with

New Version 26

changes.mady.by.user Lefty Leverenz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: add a link to HIVE-10007 in Existing Tables section, trivial edits

...

Code Block
ANALYZE TABLE [db_name.]tablename [PARTITION(partcol1[=val1], partcol2[=val2], ...)]  -- (Note: Fully support qualified table name since Hive 1.2.0, see HIVE-10007 .)
  COMPUTE STATISTICS 
  [FOR COLUMNS]          -- (Note: Hive 0.10.0 and later.)
  [NOSCAN];

When the user issues that command, he may or may not specify the partition specs. If the user doesn't specify any partition specs, statistics are gathered for the table as well as all the partitions (if any). If certain partition specs are specified, then statistics are gathered for only those partitions. When computing statistics across all partitions, the partition columns still need to be listed. Since As of Hive 1.2.0, Hive starts to fully support supports qualified table name in this command. User can only compute the statistics for a table under current database if a non-qualified table name is used.

...