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 10ABFD761 for ; Fri, 8 Feb 2013 06:21:06 +0000 (UTC) Received: (qmail 51960 invoked by uid 500); 8 Feb 2013 06:21:00 -0000 Delivered-To: apmail-hadoop-hdfs-user-archive@hadoop.apache.org Received: (qmail 51693 invoked by uid 500); 8 Feb 2013 06:21:00 -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 51675 invoked by uid 99); 8 Feb 2013 06:20:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Feb 2013 06:20:59 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_FRT_BELOW2 X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of samir.helpdoc@gmail.com designates 209.85.128.179 as permitted sender) Received: from [209.85.128.179] (HELO mail-ve0-f179.google.com) (209.85.128.179) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Feb 2013 06:20:52 +0000 Received: by mail-ve0-f179.google.com with SMTP id da11so3106246veb.10 for ; Thu, 07 Feb 2013 22:20:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=Zvkj8fyKnax9CDMKRppK4bP2TfZkp0JCobwsFUw0hjQ=; b=1HdEYPN5h/met2wvd3+PuVZmFS8XGSeUDBDBIlO+JVIYW0qt03b+P1sn1Io6SWOOji MJ8NzCSt3sBO4aizVVGOSkaIA52g/Y0L9yK76wRrg7EGRFMsplwVv/dyqZ5KlEtYtcRY r3J3rcV2kzeqLPdrjHk4iCy9B0t32JSqWznNsrXazRjaeNu57iw8j6kjYEPrLPAswjwk 4KIokH5YCFxNUMyKTYU9xq0yevYTO6OcdtBadJAslr84uTedKxZPxT04C8mmb0RNBHUC IzAGCJ9+eCsQGZLfsieAhCBtFz8CdLRVrMI43JNtYVG8aoQ1lE4BlR5X/qYDo7ylOgra xMiw== MIME-Version: 1.0 X-Received: by 10.52.92.225 with SMTP id cp1mr4571675vdb.41.1360304431437; Thu, 07 Feb 2013 22:20:31 -0800 (PST) Received: by 10.58.118.212 with HTTP; Thu, 7 Feb 2013 22:20:31 -0800 (PST) In-Reply-To: References: Date: Fri, 8 Feb 2013 11:50:31 +0530 Message-ID: Subject: Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)" From: samir das mohapatra To: user@hadoop.apache.org Content-Type: multipart/alternative; boundary=20cf307f3b346c17c704d5308ee3 X-Virus-Checked: Checked by ClamAV on apache.org --20cf307f3b346c17c704d5308ee3 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi Suresh, Thanks for advice, why you are so monopoly, You shoul not be. Problem is solution not problem. Note: I am looking for any user does not matter bcz it is common use Scenario. On Fri, Feb 8, 2013 at 3:31 AM, Suresh Srinivas wro= te: > Please only use CDH mailing list and do not copy this to hdfs-user. > > > On Thu, Feb 7, 2013 at 7:20 AM, samir das mohapatra < > samir.helpdoc@gmail.com> wrote: > >> Any Suggestion................... >> >> >> On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra < >> samir.helpdoc@gmail.com> wrote: >> >>> Hi All, >>> I could not see the hive meta store DB under Mysql database Under >>> mysql user hadoop. >>> >>> Example: >>> >>> $> mysql =96u root -p >>> $> Add hadoop user (CREATE USER =91hadoop'@'localhost' IDENTIFIED BY = =91 >>> hadoop';) >>> $>GRANT ALL ON *.* TO =91hadoop'@=91% IDENTIFIED BY =91hadoop=92 >>> $> 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=3Dtr= ue >>> >>> >>> 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 mysq= l >>> metastore DB but when i changed cdh3 to cdh4.1.2 with hive as above sub= ject >>> line , It is not creating. >>> >>> >>> Any suggestiong.......................... >>> >>> Regrads, >>> samir. >>> >> >> > > > -- > http://hortonworks.com/download/ > --20cf307f3b346c17c704d5308ee3 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable
Hi Suresh,<= br>
=A0=A0 Thank= s for advice,

=A0=A0=A0 why you are so monopoly, Y= ou shoul not be. Problem is solution not problem.

Note: I am looking for any user does not matter bcz it is common = use Scenario.


On Fri, Feb 8, 2013 at 3:31 AM, Suresh Srinivas <suresh@hor= tonworks.com> wrote:
Please only use CDH mailing= list and do not copy this to hdfs-user.


On Thu, Feb 7, 2013 at 7:20 AM, samir da= s mohapatra <samir.helpdoc@gmail.com> wrote:
Any Suggestion.............= ......


On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra &l= t;samir.helpdo= c@gmail.com> wrote:
Hi All,
=A0 I could not see the hive meta=A0 store DB under Mys= ql=A0 database Under mysql user hadoop.

Example:
=A0=A0=20
$>= ;=A0 mysql =96u= root -p
$> <= /span>Add hadoop user (CREATE USER =91hadoop'@'= localhost' = IDENTIFIED BY =91hadoop';)=
$>= GRANT ALL ON *.* TO =91hadoop'@= =91% IDENTIFIED BY =91hadoop= =92
$> <= /span>Example (GRANT ALL PRIVILEGES ON *.* TO 'hadoop'@'localhost' IDENTIFIED BY 'hadoop' WITH GRANT OPTION;)

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

<property>
=A0=A0=A0 &l= t;name>javax.jdo.option.ConnectionURL</name>
=A0=A0=A0 <valu= e>jdbc:mysql://localhost:3306/hadoop?createDatabaseIfNotExist=3Dtrue<= /value>
</property>
<property>
=A0=A0=A0 <name>javax.jdo.op= tion.ConnectionDriverName</name>
=A0=A0=A0 <value>com.mysql.= jdbc.Driver</value>
</property>
<property>
=A0 &= lt;name>javax.jdo.option.ConnectionUserName</name>
=A0 <value>hadoop</value>
</property>
<property&= gt;
=A0=A0 <name>javax.jdo.option.ConnectionPassword</name><= br>=A0=A0 <value>hadoop</value>

</property>

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.




--
http://hortonworks.com/d= ownload/
--20cf307f3b346c17c704d5308ee3--