You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by "Mark Schramm (tetrascend)" <ms...@tetrascend.com> on 2012/01/24 19:58:54 UTC

derby related files show up when using MySQL

I have configured hive to use MySQL.  This all seems to work fine, but
occasionally derby.log files and TempStatsStore directories get created as
if I was using the default derby database.  Is this an indication that I
have something misconfigured?  Can anyone explain why this happens?

 

Thanks,

Mark

RE: derby related files show up when using MySQL

Posted by "Mark Schramm (tetrascend)" <ms...@tetrascend.com>.

Edward - Mystery solved, thanks! - Mark

From: Edward Capriolo [mailto:edlinuxguru@gmail.com] 
Sent: Tuesday, January 24, 2012 11:17 AM
To: user@hive.apache.org
Subject: Re: derby related files show up when using MySQL

This took me a while to figure out. Hive has this feature where it will
automatically collect table stats ONLY during 'insert overwrite' queries.
This feature is still being worked on and is only useful for indexing. 

You should set this in your hive-site.xml

  <property>
    <name>hive.stats.autogather</name>
    <value>false</value>
  </property>

Edward

On Tue, Jan 24, 2012 at 1:58 PM, Mark Schramm (tetrascend)
<ms...@tetrascend.com> wrote:

I have configured hive to use MySQL.  This all seems to work fine, but
occasionally derby.log files and TempStatsStore directories get created as
if I was using the default derby database.  Is this an indication that I
have something misconfigured?  Can anyone explain why this happens?

Thanks,

Mark

Re: derby related files show up when using MySQL

Posted by Edward Capriolo <ed...@gmail.com>.

This took me a while to figure out. Hive has this feature where it will
automatically collect table stats ONLY during 'insert overwrite' queries.
This feature is still being worked on and is only useful for indexing.

You should set this in your hive-site.xml

  <property>
    <name>hive.stats.autogather</name>
    <value>false</value>
  </property>

Edward

On Tue, Jan 24, 2012 at 1:58 PM, Mark Schramm (tetrascend) <
mschramm@tetrascend.com> wrote:

> I have configured hive to use MySQL.  This all seems to work fine, but
> occasionally derby.log files and TempStatsStore directories get created as
> if I was using the default derby database.  Is this an indication that I
> have something misconfigured?  Can anyone explain why this happens?****
>
> ** **
>
> Thanks,****
>
> Mark****
>