Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id F32AA105B9 for ; Mon, 3 Feb 2014 01:02:00 +0000 (UTC) Received: (qmail 30694 invoked by uid 500); 3 Feb 2014 01:01:43 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 30548 invoked by uid 500); 3 Feb 2014 01:01:38 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 30456 invoked by uid 500); 3 Feb 2014 01:01:36 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 30423 invoked by uid 99); 3 Feb 2014 01:01:33 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Feb 2014 01:01:33 +0000 Date: Mon, 3 Feb 2014 01:01:33 +0000 (UTC) From: "Naga Vijay (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (HIVE-6352) Hive 0.11 & Hive 0.12 - derby.log and TempStatsStore are created when using MySQL Metastore MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-6352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naga Vijay updated HIVE-6352: ----------------------------- Summary: Hive 0.11 & Hive 0.12 - derby.log and TempStatsStore are created when using MySQL Metastore (was: Hive 0.11 & Hive 0.12 - derby.log and TempStatsStore are created) > 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)