Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # dev >> [jira] [Created] (HIVE-6352) Hive 0.11 & Hive 0.12 - Hive MySQL Metastore is not used for INSERT


Copy link to this message
-
[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)