Edward - Mystery solved, thanks! - Mark
From: Edward Capriolo [mailto:edlinuxg...@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) <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
