You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by wd <wd...@wdicc.com> on 2011/05/10 12:07:29 UTC

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 hive job .
What does these files do? Is there a way to prevent them created ?

RE: What does 'TempStatsStore' do ?

Posted by "Raghunath, Ranjith" <Ra...@usaa.com>.
Is there some advantage to gathering stats in this case?

Thank you,
Ranjith N. Raghunath

From: wd [mailto:wd@wdicc.com]
Sent: Tuesday, May 10, 2011 9:54 PM
To: user@hive.apache.org
Subject: Re: What does 'TempStatsStore' do ?

Thanks, I found some new configure options for hive.stats, I'll change them.


2011/5/11 Ning Zhang <nz...@fb.com>>
TempStatsStore is a derby database for stats gathering (intermediate stats). You can turn off stats gathering by set hive.stats.autogather=false.

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


I don't 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 directory.  I also never saw anything useful in that file.  I delete it whenever I see it.

What's in TempStatsStore?

Pat

From: wd [mailto:wd@wdicc.com<ma...@wdicc.com>]
Sent: Tuesday, May 10, 2011 3:07 AM
To: hive-user@hadoop.apache.org<ma...@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 hive job . What does these files do? Is there a way to prevent them created ?



Re: What does 'TempStatsStore' do ?

Posted by wd <wd...@wdicc.com>.
Thanks, I found some new configure options for hive.stats, I'll change them.


2011/5/11 Ning Zhang <nz...@fb.com>

>  TempStatsStore is a derby database for stats gathering (intermediate
> stats). You can turn off stats gathering by set
> hive.stats.autogather=false.
>
>  On May 10, 2011, at 1:23 PM, Christopher, Pat wrote:
>
>   I don’t 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 directory.
> I also never saw anything useful in that file.  I delete it whenever I see
> it.
>
>  What’s 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 hive
> job . What does these files do? Is there a way to prevent them created ?
>
>
>

Re: What does 'TempStatsStore' do ?

Posted by Ning Zhang <nz...@fb.com>.
TempStatsStore is a derby database for stats gathering (intermediate stats). You can turn off stats gathering by set hive.stats.autogather=false.

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

I don’t 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 directory.  I also never saw anything useful in that file.  I delete it whenever I see it.

What’s in TempStatsStore?

Pat

From: wd [mailto:wd@wdicc.com]
Sent: Tuesday, May 10, 2011 3:07 AM
To: hive-user@hadoop.apache.org<ma...@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 hive job . What does these files do? Is there a way to prevent them created ?


RE: What does 'TempStatsStore' do ?

Posted by "Christopher, Pat" <pa...@hp.com>.
I don't 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 directory.  I also never saw anything useful in that file.  I delete it whenever I see it.

What's 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 hive job . What does these files do? Is there a way to prevent them created ?