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/03 03:12:11 UTC
[jira] [Resolved] (HIVE-6352) Hive 0.11 & Hive 0.12 - derby.log and
TempStatsStore are created when using MySQL Metastore
[ https://issues.apache.org/jira/browse/HIVE-6352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Naga Vijay resolved HIVE-6352.
------------------------------
Resolution: Not A Problem
Not a Problem, as we can avoid creation of derby.log and TempStatsStore by setting hive.stats.autogather to false.
> Hive 0.11 & Hive 0.12 - derby.log and TempStatsStore are created when using MySQL Metastore
> -------------------------------------------------------------------------------------------
>
> 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
> Attachments: th.zip
>
>
> 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)