[ https://issues.apache.org/jira/browse/HIVE-6352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Naga Vijay resolved HIVE-6352. ------------------------------ Resolution: Not A Problem Not a Problem, as we can avoid creation of derby.log and TempStatsStore by setting hive.stats.autogather to false. > Hive 0.11 & Hive 0.12 - derby.log and TempStatsStore are created when using > MySQL Metastore > ------------------------------------------------------------------------------------------- > > Key: HIVE-6352 > URL: https://issues.apache.org/jira/browse/HIVE-6352 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 0.12.0 > Environment: hadoop 1.2.1 > hive 0.12.0 > Reporter: Naga Vijay > Attachments: th.zip > > > Hi, > I am facing this situation for the below mentioned hql file - > > Hive MySQL Metastore is used for table t1 > > Hive MySQL Metastore is not used for table t2 (derby.log is created in the > > directory) > ---------- > -- database pp_test_hive_metastore > drop database if exists pp_test_hive_metastore cascade; > create database pp_test_hive_metastore; > use pp_test_hive_metastore; > -- table t1 > create table t1 ( id int, name string ); > LOAD DATA LOCAL INPATH 'testHiveMetastore.txt' OVERWRITE INTO TABLE t1; > select * from t1; > select count(*) from t1; > -- table t2 > create table t2 ( id int, name string ); > INSERT OVERWRITE TABLE t2 SELECT t.* FROM t1 t; > select * from t2; > select count(*) from t2; > -- done > quit; > --------------- > Testing Procedure : Comment/Uncomment the lines for table t2 -- This message was sent by Atlassian JIRA (v6.1.5#6160)