[HIVE-6352] Hive 0.11 & Hive 0.12 - derby.log and TempStatsStore are created when using MySQL Metastore

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.12.0
• Component/s: Metastore

Environment

hadoop 1.2.1

hive 0.12.0

• Assignee: Unassigned
• Reporter: Naga Vijay
• Created: 02/Feb/14 22:09
• Updated: 03/Feb/14 02:10
• Resolved: 03/Feb/14 02:10

Description

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