THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
| Info | ||
|---|---|---|
| ||
As of Hive 0.10.0, the optional parameter FOR COLUMNS computes column statistics for all columns in the specified table (and for all partitions if the table is partitioned). See Column Statistics in Hive for details. To display these statistics, use DESCRIBE FORMATTED [db_name.]table_name.column_name [PARTITION (partition_spec)]. |
...
then column statistics are gathered for all columns for partition3 (ds='2008-04-09', hr=11). This is available in Hive 0.10.0 and later.
If you issue the command:
...
then column statistics for all columns are gathered for partitions 3 and 4 only (Hive 0.10.0 and later).
If you issue the command:
...
then column statistics for all columns are gathered for all four partitions (Hive 0.10.0 and later).
For a non-partitioned table, you can issue the command:
...
to gather column statistics of the table (Hive 0.10.0 and later).
If Table1 is a partitioned table, then for basic statistics you have to specify partition specifications like above in the analyze statement. Otherwise a semantic analyzer exception will be thrown.
...