Return-Path: X-Original-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D22FAE4CD for ; Thu, 7 Feb 2013 23:09:37 +0000 (UTC) Received: (qmail 51047 invoked by uid 500); 7 Feb 2013 23:09:32 -0000 Delivered-To: apmail-hadoop-hdfs-user-archive@hadoop.apache.org Received: (qmail 50885 invoked by uid 500); 7 Feb 2013 23:09:32 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 50876 invoked by uid 99); 7 Feb 2013 23:09:32 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Feb 2013 23:09:32 +0000 X-ASF-Spam-Status: No, hits=0.7 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL,T_FRT_BELOW2 X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [76.96.30.17] (HELO qmta10.emeryville.ca.mail.comcast.net) (76.96.30.17) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Feb 2013 23:09:25 +0000 Received: from omta07.emeryville.ca.mail.comcast.net ([76.96.30.59]) by qmta10.emeryville.ca.mail.comcast.net with comcast id xb6d1k0041GXsucAAb95pl; Thu, 07 Feb 2013 23:09:05 +0000 Received: from boudnik.org ([24.4.185.157]) by omta07.emeryville.ca.mail.comcast.net with comcast id xb941k00Z3QAh8g8Ub940t; Thu, 07 Feb 2013 23:09:05 +0000 Received: from mail.boudnik.org (localhost [127.0.0.1]) by boudnik.org (8.14.3/8.14.3/Debian-5+lenny1) with ESMTP id r17N93OP025229; Thu, 7 Feb 2013 15:09:03 -0800 Received: (from cos@localhost) by mail.boudnik.org (8.14.3/8.14.3/Submit) id r17N93wf025228; Thu, 7 Feb 2013 15:09:03 -0800 X-Authentication-Warning: mail.boudnik.org: cos set sender to cos@apache.org using -f Date: Thu, 7 Feb 2013 15:09:03 -0800 From: Konstantin Boudnik To: Viral Bajaria Cc: samir das mohapatra Subject: Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with Message-ID: <20130207230903.GU17164@linspire.com> References: <3822509882653204281@unknownmsgid> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <3822509882653204281@unknownmsgid> X-Organization: It's something of 'Cos User-Agent: Mutt/1.5.18 (2008-05-17) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20121106; t=1360278545; bh=piDJl0/RaXK7YkOUYTRSqt0AT96njYwi9xcvRcK+8+s=; h=Received:Received:Received:Received:Date:From:To:Subject: Message-ID:MIME-Version:Content-Type; b=WIxJgTpl3zL3GCzrQ760fGPiSH1yCm5qerWDztrzw/7mEa6oBVd7sPKrYQdm1VYrP qa9gF+wjEQdzGxFekio9NQwMU812382FXCxfG2oJuf1VNWFZkA1M/HtZ0sNtNTwp+3 Mz+MS8ouzIaVlDro6uqCFRHdCPa9izRqycLv2/zODFiglTsGGsu8+7NORlXaiCTjsg 4VCS8JcdK7FoMDLL3vaoNyrWbZYzkFN8bCbqS1Iyf8kV2xBTbXKZgZ7znTKMcYNnyK SiQhrQIJC7qrHy40SFtujgUaAP9R9kElEuQ0WSQE2TPl3n3zBtKsI0Gi1PVAJ44WSQ mhpyU3ilVRwjg== X-Virus-Checked: Checked by ClamAV on apache.org Don't cross post to irrelevant (user@hadoop) forums. On Thu, Feb 07, 2013 at 03:30AM, Viral Bajaria wrote: > hive-0.9.0-cdh4.1.2)" > MIME-Version: 1.0 > Content-Type: multipart/alternative; boundary=bcaec502d692f132a604d5202931 > > --bcaec502d692f132a604d5202931 > Content-Type: text/plain; charset="utf-8" > Content-Transfer-Encoding: quoted-printable > > When you run a hive command like show tables or show databases, do you > see any errors ? > > If yes, can you paste those ? > > Viral > From: samir das mohapatra > Sent: 2/7/2013 2:47 AM > To: user@hadoop.apache.org; cdh-user@cloudera.org > Subject: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with > hive-0.9.0-cdh4.1.2)" > Hi All, > I could not see the hive meta store DB under Mysql database Under mysql > user hadoop. > > Example: > > $> mysql =E2=80=93u root -p > $> Add hadoop user (CREATE USER =E2=80=98hadoop'@'localhost' IDENTIFIED BY = > =E2=80=98hadoop > ';) > $>GRANT ALL ON *.* TO =E2=80=98hadoop'@=E2=80=98% IDENTIFIED BY =E2=80=98ha= > doop=E2=80=99 > $> Example (GRANT ALL PRIVILEGES ON *.* TO 'hadoop'@'localhost' IDENTIFIED > BY 'hadoop' WITH GRANT OPTION;) > > Bellow configuration i am follwing > ------------------------------------------------ > > > javax.jdo.option.ConnectionURL > > jdbc:mysql://localhost:3306/hadoop?createDatabaseIfNotExist=3Dtrue value> > > > javax.jdo.option.ConnectionDriverName > com.mysql.jdbc.Driver > > > javax.jdo.option.ConnectionUserName > hadoop > > > javax.jdo.option.ConnectionPassword > hadoop > > > > > Note: Previously i was using cdh3 it was perfectly creating under mysql > metastore DB but when i changed cdh3 to cdh4.1.2 with hive as above subject > line , It is not creating. > > > Any suggestiong.......................... > > Regrads, > samir. > > --bcaec502d692f132a604d5202931 > Content-Type: text/html; charset="utf-8" > Content-Transfer-Encoding: quoted-printable > > ent-Type">
font-size: 11pt;">When you run a hive command like show tables or show data= > bases, do you see any errors ?

If yes, can you paste those ?

= > Viral
t-size: 10pt; font-weight: bold;">From: Tahoma,sans-serif; font-size: 10pt;">samir das mohapatra
yle=3D"font-family: Tahoma,sans-serif; font-size: 10pt; font-weight: bold;"= > >Sent: t;">2/7/2013 2:47 AM
f; font-size: 10pt; font-weight: bold;">To: ly: Tahoma,sans-serif; font-size: 10pt;">user@hadoop.apache.org; cdh-user@c= > loudera.org
ize: 10pt; font-weight: bold;">Subject: Tahoma,sans-serif; font-size: 10pt;">"Hive Metastore DB Issue ( Cloudera CD= > H4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"

=3D"ltr">
Hi All,
=C2=A0 I could not = > see the hive meta=C2=A0 store DB under Mysql=C2=A0 database Under mysql use= > r hadoop.

Example:
=C2=A0=C2=A0=20 > >
lign:left;direction:ltr;vertical-align:baseline"> 6pt"> > normal">$>=C2=A0 mysql k;font-weight:normal"> =E2=80=93u root -p
> > >
;text-align:left;direction:ltr;vertical-align:baseline"> pan>$> <= > /span>Add > had= > oop= > user (CREATE USER =E2=80=98 lack;font-weight:normal">hadoop'@'localhost nt-family:Arial;color:black;font-weight:normal">' IDENTIFIED BY =E2=80= > =98= > hadoop l">';)
> > >
;text-align:left;direction:ltr;vertical-align:baseline"> pan style=3D"font-family:Arial;color:black;font-weight:normal"> t> dings">$> y:Arial;color:black;font-weight:normal">GRANT > ALL ON *.* TO =E2=80=98 font-weight:normal">hadoop ck;font-weight:normal">'@=E2=80=98% IDENTIFIED BY =E2=80=98 style=3D"font-family:Arial;color:black;font-weight:normal">hadoop pan style=3D"font-family:Arial;color:black;font-weight:normal">=E2=80=99 pan>
> > >
;text-align:left;direction:ltr;vertical-align:baseline"> pan>$> <= > /span> an> t-weight:normal">Example > (GRANT ALL PRIVILEGES ON *.* TO ' l;color:black;font-weight:normal">hadoop rial;color:black;font-weight:normal">'@' family:Arial;color:black;font-weight:normal">localhost "font-family:Arial;color:black;font-weight:normal">' IDENTIFIED BY '= > ;ha= > doop >' WITH GRANT OPTION;)
> > > > >

Bellow=C2=A0 configuration i am follwing
----------= > --------------------------------------

<property>
=C2=A0=C2= > =A0=C2=A0 <name>javax.jdo.option.ConnectionURL</name>
=C2=A0= > =C2=A0=C2=A0 <value>jdbc:mysql://localhost:3306/hadoop?createDatabase= > IfNotExist=3Dtrue</value>
> </property>
<property>
=C2=A0=C2=A0=C2=A0 <name>jav= > ax.jdo.option.ConnectionDriverName</name>
=C2=A0=C2=A0=C2=A0 <v= > alue>com.mysql.jdbc.Driver</value>
</property>
<pro= > perty>
=C2=A0 <name>javax.jdo.option.ConnectionUserName</nam= > e>
> =C2=A0 <value>hadoop</value>
</property>
<proper= > ty>
=C2=A0=C2=A0 <name>javax.jdo.option.ConnectionPassword</= > name>
=C2=A0=C2=A0 <value>hadoop</value>

</prop= > erty>


> Note: Previously i was using cdh3 it was perfectly creating under mysql met= > astore DB but when i changed cdh3 to cdh4.1.2 with hive as above subject li= > ne , It is not creating.


Any suggestiong..................= > ........
>
Regrads,
samir.
> > --bcaec502d692f132a604d5202931--