hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Naga Vijay (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6352) Hive 0.11 & Hive 0.12 - derby.log and TempStatsStore are created
Date Mon, 03 Feb 2014 00:44:08 GMT

    [ https://issues.apache.org/jira/browse/HIVE-6352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13889133#comment-13889133
] 

Naga Vijay commented on HIVE-6352:
----------------------------------

Modified the title of this JIRA to reflect the issue after further testing.

Here's the test setup -

> find . -type f
./th12a/testHiveMetastore.hql
./th12a/testHiveMetastore.sh
./th12a/testHiveMetastore.txt
./th12b/testHiveMetastore.hql
./th12b/testHiveMetastore.sh

> Ran script in th12a dir - noticed derby.log and TempStatsStore dir being created in th12a
dir
> Ran script in th12b dir - table t2 has data, so MySQL Metastore is used ; verified in
HDFS as well

So, the issue is - derby.log and TempStatsStore dir are created in th12a dir when using MySQL
Metastore

> Hive 0.11 & Hive 0.12 - derby.log and TempStatsStore are created
> ----------------------------------------------------------------
>
>                 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)

Mime
View raw message