Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded 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)

 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB