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 19:18:43 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=53&rev2=54

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

  }}}
  then statistics are gathered for the 4 partitions as well as the table itself.
  
- The user can view the stored statistics by issuing the [[http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?highlight=(describe)#Describe_Partition|DESCRIBE]]
command. Suppose the user issues the analyze command for the whole table Table1. If the user
issues the following commands:
+ The user can view the stored statistics by issuing the [[http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?highlight=(describe)#Describe_Partition|DESCRIBE]]
command. Statistics are stored in the Parameters array. Suppose the user issues the analyze
command for the whole table Table1, then issues the command:
  {{{
  DESCRIBE EXTENDED TABLE1;
- DESCRIBE EXTENDED TABLE1 PARTITION(ds='2008-04-08', hr=12);
- DESCRIBE EXTENDED TABLE1 PARTITION(ds='2008-04-09', hr=11);
- DESCRIBE EXTENDED TABLE1 PARTITION(ds='2008-04-08', hr=12);
+ }}}
+ then among the output, the following would be displayed:
+ {{{
+    ... , parameters:{numPartitions=4, numFiles=16, numRows=2000, totalSize=16384, ....},
....
+ }}}
+ 
+ If the user issues the command:
+ {{{
  DESCRIBE EXTENDED TABLE1 PARTITION(ds='2008-04-09', hr=11);
  }}}
+ then among the output, the following would be displayed:
+ {{{
+    ... , parameters:{numFiles=4, numRows=500, totalSize=4096, ....}, ....
+ }}}
  

Mime
View raw message