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 F2544E7CC for ; Thu, 7 Feb 2013 10:47:41 +0000 (UTC) Received: (qmail 80549 invoked by uid 500); 7 Feb 2013 10:47:37 -0000 Delivered-To: apmail-hadoop-hdfs-user-archive@hadoop.apache.org Received: (qmail 80087 invoked by uid 500); 7 Feb 2013 10:47:36 -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 80049 invoked by uid 99); 7 Feb 2013 10:47:35 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Feb 2013 10:47:35 +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.220.182 as permitted sender) Received: from [209.85.220.182] (HELO mail-vc0-f182.google.com) (209.85.220.182) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Feb 2013 10:47:27 +0000 Received: by mail-vc0-f182.google.com with SMTP id fl17so1530683vcb.13 for ; Thu, 07 Feb 2013 02:47:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:date:message-id:subject:from:to :content-type; bh=fsyNfdMsZzfM28gZZzglZEQqFxInxD8PY4A3Gisw/k4=; b=0O1qyoNjEByotOrOnx9osRgVLTJRzMG5eKlq0u3WNgoNH/3E+LXmb5H4AK+q1ROWGI 2kHF0Q14FLqHBM8odcHCK1qy5ue7MisCLJzns9YoTyI9cVJnj61Iye2qbDSy+Ps1DHaM Uz2590r6UvTu7T1DAtkiUPnew+QV3ggay7dYTb4wcMVseq3YeGil4i+SXk0o0Hh6Ok8s 2z7auw9z/rRFtsAH2aKAQacCZZfkftbuud1wLsnDdRpKaIKFEfIv2aXvTwZQq07q041k Cvt0S9Y6QhtHt2DU0Y3YK2pMNy5U4OEhQaKoEqJNIMGVqkY/7wdap/OGAhwoC6FqWpNw 2hVQ== MIME-Version: 1.0 X-Received: by 10.52.16.65 with SMTP id e1mr774115vdd.127.1360234026185; Thu, 07 Feb 2013 02:47:06 -0800 (PST) Received: by 10.58.118.212 with HTTP; Thu, 7 Feb 2013 02:47:05 -0800 (PST) Date: Thu, 7 Feb 2013 16:17:05 +0530 Message-ID: Subject: "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, cdh-user@cloudera.org Content-Type: multipart/alternative; boundary=bcaec502d692f132a604d5202931 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec502d692f132a604d5202931 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable 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 =91had= oop ';) $>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=3Dtrue 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=windows-1252 Content-Transfer-Encoding: quoted-printable

Hi All,

=A0 I could= not see the hive meta=A0 store DB under Mysql=A0 database Under mysql user= hadoop.

Example:
=A0=A0=20

$>=A0 mysql =96u root -p

$> <= /span>Add had= oop= 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 '= ;ha= doop' 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.

--bcaec502d692f132a604d5202931--