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) <
mschr...@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****
>
