Naga Vijay created HIVE-6352: -------------------------------- Summary: Hive 0.11 & Hive 0.12 - Hive MySQL Metastore is not used for INSERT 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 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)