Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 959A1105DA for ; Mon, 3 Feb 2014 01:03:19 +0000 (UTC) Received: (qmail 35142 invoked by uid 500); 3 Feb 2014 01:03:17 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 35076 invoked by uid 500); 3 Feb 2014 01:03:16 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 35068 invoked by uid 99); 3 Feb 2014 01:03:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Feb 2014 01:03:16 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of nagahive@gmail.com designates 209.85.212.68 as permitted sender) Received: from [209.85.212.68] (HELO mail-vb0-f68.google.com) (209.85.212.68) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Feb 2014 01:03:12 +0000 Received: by mail-vb0-f68.google.com with SMTP id f12so1163801vbg.7 for ; Sun, 02 Feb 2014 17:02:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=rrpVcLWjI2jWcQs+eKz9b82rOM9km1mI7nQklOGf5Ck=; b=mU+MswvhvurDN06HJp89AjuQccNVVdbjjKrmZ+Hb2ply9Xxw1GCl0AytmkHotwVNj6 Y+3ZzokLEZKpFXfKNmjcmA9MGL1tugycTPK3mNireNA9YxO2mFdCptT/fTksWtlDJybZ i57jW1rVlGsqxUsOfBB4BA7hoce648F4P42BcembMhrWuuKIXjjpTDR0mm6cQubFlveP jKAAlQnDQkJ5BJZLXytkZ7WbVuLan5gda96iSh5u7XcAzuXf8hrwf9iTCp8UErSbQG8C a4KZlXywbK7L9LkQZHhj1rmCRFYUOQZkhxyOy+6EarKM0Zr32U4lhQXJTHNMspXpGyuf or7w== MIME-Version: 1.0 X-Received: by 10.58.90.202 with SMTP id by10mr25406601veb.6.1391389371958; Sun, 02 Feb 2014 17:02:51 -0800 (PST) Received: by 10.58.76.196 with HTTP; Sun, 2 Feb 2014 17:02:51 -0800 (PST) In-Reply-To: References: Date: Sun, 2 Feb 2014 17:02:51 -0800 Message-ID: Subject: Re: Hive 0.11 & Hive 0.12 - Hive MySQL Metastore is not used for INSERT From: Naga Vijay To: Matouk IFTISSEN Cc: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a1136a478428ae304f17615f4 X-Virus-Checked: Checked by ClamAV on apache.org --001a1136a478428ae304f17615f4 Content-Type: text/plain; charset=ISO-8859-1 I have modified the title of the JIRA to properly reflect the issue faced - Hive 0.11 & Hive 0.12 - derby.log and TempStatsStore are created when using MySQL Metastore Regards Naga On Sun, Feb 2, 2014 at 2:15 PM, Naga Vijay wrote: > Hi, > > I have checked my hive-site.xml ; it is fine ; hive metastore service is > running as well. > > I have logged this - https://issues.apache.org/jira/browse/HIVE-6352 > > Regards > Naga > > > On Sun, Feb 2, 2014 at 9:11 AM, Matouk IFTISSEN < > matouk.iftissen@ysance.com> wrote: > >> Hello, >> see your hie-site.xml file, and check the database connexion( connexion >> string) because in this file, that happend connexion to the metastore when >> you start Hive. >> >> Hope this helps you. >> regards. >> Matouk >> >> >> 2014-02-02 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 >>> >>> Can someone throw some light on this? >>> >>> Thanks >>> Naga >>> >>> >> >> >> -- >> >> *Matouk IFTISSEN | Consultant BI & Big Data [image: >> http://www.ysance.com] * >> 24 rue du sentier - 75002 Paris - www.ysance.com >> Mob : +33 6 78 51 18 69 || Fax : +33 1 73 72 97 26 >> *Ysance sur* :*Twitter* * | Facebook >> | Google+ >> | LinkedIn >> | Newsletter >> * >> *Nos autres sites* : *ys4you* * | labdecisionnel >> | decrypt * >> > > --001a1136a478428ae304f17615f4 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
I have modified the title of the JIRA to properly ref= lect the issue faced -

Hive 0.11 & Hive 0.12 - derby.log and Tem= pStatsStore are created when using MySQL Metastore

Regar= ds
Naga


On Sun, Feb 2, 2014 at 2:15 PM, Naga Vijay <nagahive@gmail.com= > wrote:
Hi,

I= have checked my hive-site.xml ; it is fine ; hive metastore service is run= ning as well.

I have logged this - https://issues.apache.org/jira/browse/HIV= E-6352

Regards
=
Naga
=


On Sun, Feb 2, 2014 at 9:11 AM, Matouk IFTIS= SEN <matouk.iftissen@ysance.com> wrote:
Hello,
see your hie-sit= e.xml file, and check the database connexion( connexion string) because in = this file, that happend connexion to the metastore when you start Hive.

Hope this helps you.
regards.
Matouk

2014-02-02 Naga Vijay <nagahive@gmail.com>:

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 da= tabase if exists pp_test_hive_metastore cascade;

create database pp_= test_hive_metastore;

use pp_test_hive_metastore;

-- table t1<= br>
create table t1 ( id int, name string );

LOAD DATA LOCAL INPATH = 'testHiveMetastore.txt' OVERWRITE INTO TABLE t1;

select * fr= om t1;=A0=A0

select count(*) from t1;

-- table t2

cre= ate table t2 ( id int, name string );

INSERT OVERWRITE TABLE t2 SELECT t.* FROM t1 t;

select * from t2= ;=A0=A0

select count(*) from t2;

-- done

quit;
---------------

Testing Procedure : Comment/Uncomment th= e lines for table t2

Can someone throw some light on this?

Thanks
Naga




--
Matouk IFTISSEN | Consultant BI & Big Data=
3D==A0
24 rue du sentier - 7= 5002 Paris -=A0www.ysance.com
Mob :=A0+33 6 = 78 51 18 69=A0|| = Fax :=A0+33 1 73 72 97 26=A0
Ysance sur= =A0:Twitter= =A0|=A0Facebook= =A0|=A0Google+=A0|=A0LinkedIn=A0|=A0Newsletter
Nos autres sites=A0:=A0<= a href=3D"http://wwww.ys4you.com/" style=3D"color:rgb(173,39,51);font-famil= y:'Lucida Grande',Verdana,Arial,sans-serif;font-size:11px;line-heig= ht:17px;text-decoration:none;border-bottom-width:1px;border-bottom-color:rg= b(51,51,51);border-bottom-style:dotted" target=3D"_blank">ys4you=A0|=A0labdecisionnel=A0|=A0decrypt


--001a1136a478428ae304f17615f4--