Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id AFC9047E6 for ; Wed, 11 May 2011 02:54:20 +0000 (UTC) Received: (qmail 78269 invoked by uid 500); 11 May 2011 02:54:20 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 78140 invoked by uid 500); 11 May 2011 02:54:18 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 78132 invoked by uid 99); 11 May 2011 02:54:17 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 May 2011 02:54:17 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [209.85.212.182] (HELO mail-px0-f182.google.com) (209.85.212.182) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 May 2011 02:54:12 +0000 Received: by pxi20 with SMTP id 20so82825pxi.41 for ; Tue, 10 May 2011 19:53:52 -0700 (PDT) MIME-Version: 1.0 Received: by 10.68.40.197 with SMTP id z5mr12251044pbk.503.1305082431843; Tue, 10 May 2011 19:53:51 -0700 (PDT) Received: by 10.68.43.39 with HTTP; Tue, 10 May 2011 19:53:51 -0700 (PDT) In-Reply-To: <94589B21-F817-4ED9-AE76-64D86B81E08E@fb.com> References: <94589B21-F817-4ED9-AE76-64D86B81E08E@fb.com> Date: Wed, 11 May 2011 10:53:51 +0800 Message-ID: Subject: Re: What does 'TempStatsStore' do ? From: wd To: user@hive.apache.org Content-Type: multipart/alternative; boundary=bcaec5304f07c0ac3604a2f72ed1 --bcaec5304f07c0ac3604a2f72ed1 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Thanks, I found some new configure options for hive.stats, I'll change them= . 2011/5/11 Ning Zhang > TempStatsStore is a derby database for stats gathering (intermediate > stats). You can turn off stats gathering by set > hive.stats.autogather=3Dfalse. > > On May 10, 2011, at 1:23 PM, Christopher, Pat wrote: > > I don=92t know what TempStatsStore is, but derby.log is an artifact of > using the default metastore db, derby. I was unable to figure out a way = to > get derby.log to not be created or to be created in a particular director= y. > I also never saw anything useful in that file. I delete it whenever I se= e > it. > > What=92s in TempStatsStore? > > Pat > > *From:* wd [mailto:wd@wdicc.com] > *Sent:* Tuesday, May 10, 2011 3:07 AM > *To:* hive-user@hadoop.apache.org > *Subject:* What does 'TempStatsStore' do ? > > hi, > > After upgrade to hive 0.7, I found there will a file named 'derby.log' > and directory named 'TempStatsStore' be created every time I run the hiv= e > job . What does these files do? Is there a way to prevent them created ? > > > --bcaec5304f07c0ac3604a2f72ed1 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable
Thanks, I found some new configure options for hive.stats, I'll ch= ange them.


2011/5/11 Nin= g Zhang <nzhang@fb.co= m>
TempStatsStore is a derby database for stats gathering (intermediate stats)= . You can turn off stats gathering by set hive.stats.autogather=3Dfalse.=A0

On May 10, 2011, at 1:23 PM, Christopher, Pat wrote:

I don=92t know what TempStatsStore is, but derby.log is an artif= act of using the default metastore db, derby.=A0 I was unable to figure out= a way to get derby.log to not be created or to be created in a particular directory.=A0 I also never saw= anything useful in that file.=A0 I delete it whenever I see it.
=A0
What=92s in TempStatsStore?
=A0
Pat
=A0
From:= =A0wd [mailto:wd@w= dicc.com]=A0
Sent:=A0Tuesday, May 10, 2011 3:07 AM
To:=A0hive-user@ha= doop.apache.org
Subject:=A0What does 'TempStatsStore' do ?
=A0
hi,
=A0
After upgrade to hive 0.7, I found there will a file named 'derby.log&#= 39; and directory named 'TempStatsStore' =A0be created every time I= run the hive job . What does these files do? Is there a way to prevent the= m created ?


--bcaec5304f07c0ac3604a2f72ed1--