hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/StatsDev" by ahmedaly
Date Thu, 29 Jul 2010 00:53:27 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The "Hive/StatsDev" page has been changed by ahmedaly.
http://wiki.apache.org/hadoop/Hive/StatsDev?action=diff&rev1=47&rev2=48

--------------------------------------------------

   *Partition4: (ds='2008-04-09', hr=12)
  and the user issues the following command:
  {{{
- ANALYZE TABLE Table1 PARTITION(ds='', hr) COMPUTE STATISTICS;
+ ANALYZE TABLE Table1 PARTITION(ds='2008-04-09', hr=11) COMPUTE STATISTICS;
  }}}
- then the 
+ then statistics are gathered for partition3 (ds='2008-04-09', hr=11) only.
  
+ If the user issues the command:
+ {{{
+ ANALYZE TABLE Table1 PARTITION(ds='2008-04-09', hr) COMPUTE STATISTICS;
+ }}}
+ then statistics are gathered for partitions 3 and 4 only.
+ 
+ If the user issues the command:
+ {{{
+ ANALYZE TABLE Table1 PARTITION(ds, hr) COMPUTE STATISTICS;
+ }}}
+ then statistics are gathered for the 4 partitions.
+ 
+ If the user issues the command:
+ {{{
+ ANALYZE TABLE Table1 COMPUTE STATISTICS;
+ }}}
+ then statistics are gathered for the 4 partitions as well as the table itself.
+ 

Mime
View raw message