Hive 0.11 & Hive 0.12 - Hive MySQL Metastore is not used for INSERT

[Naga Vijay]

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

Can someone throw some light on this?

Thanks
Naga