Return-Path: Delivered-To: apmail-hadoop-common-commits-archive@www.apache.org Received: (qmail 63949 invoked from network); 29 Jul 2010 00:40:53 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 29 Jul 2010 00:40:53 -0000 Received: (qmail 90440 invoked by uid 500); 29 Jul 2010 00:40:53 -0000 Delivered-To: apmail-hadoop-common-commits-archive@hadoop.apache.org Received: (qmail 90412 invoked by uid 500); 29 Jul 2010 00:40:52 -0000 Mailing-List: contact common-commits-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: common-dev@hadoop.apache.org Delivered-To: mailing list common-commits@hadoop.apache.org Received: (qmail 90405 invoked by uid 500); 29 Jul 2010 00:40:52 -0000 Delivered-To: apmail-hadoop-core-commits@hadoop.apache.org Received: (qmail 90402 invoked by uid 99); 29 Jul 2010 00:40:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jul 2010 00:40:52 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.131] (HELO eos.apache.org) (140.211.11.131) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jul 2010 00:40:50 +0000 Received: from eosnew.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id B819C8D; Thu, 29 Jul 2010 00:40:28 +0000 (UTC) MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable From: Apache Wiki To: Apache Wiki Date: Thu, 29 Jul 2010 00:40:28 -0000 Message-ID: <20100729004028.68110.43277@eosnew.apache.org> Subject: =?utf-8?q?=5BHadoop_Wiki=5D_Update_of_=22Hive/StatsDev=22_by_ahmedaly?= X-Virus-Checked: Checked by ClamAV on apache.org Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for ch= ange notification. The "Hive/StatsDev" page has been changed by ahmedaly. http://wiki.apache.org/hadoop/Hive/StatsDev?action=3Ddiff&rev1=3D44&rev2=3D= 45 -------------------------------------------------- = =3D=3D Examples =3D=3D Suppose table Table1 has 4 partitions with the following specs: - Partition1: ds=3D'',hr=3D11 + *Partition1: ds=3D'2008-04-08',hr=3D11 - Partition2: ds=3D'',hr=3D12 + *Partition2: ds=3D'2008-04-08',hr=3D12 - Partition3: ds=3D'',hr=3D11 + *Partition3: ds=3D'2008-04-09',hr=3D11 - Partition4: ds=3D'',hr=3D12 + *Partition4: ds=3D'2008-04-09',hr=3D12 and the user issues the following command: {{{ ANALYZE TABLE Table1 PARTITION(ds=3D'', hr) COMPUTE STATISTICS;