You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Naga Vijay (JIRA)" <ji...@apache.org> on 2014/02/02 23:10:09 UTC
[jira] [Created] (HIVE-6352) Hive 0.11 & Hive 0.12 - Hive MySQL
Metastore is not used for INSERT
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)