Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
MapReduce >> mail # user >> RE: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with


Copy link to this message
-
RE: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with
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: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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=98hadoop=E2=80=99
$> Example (GRANT ALL PRIVILEGES ON *.* TO 'hadoop'@'localhost' IDENTIFIED
BY 'hadoop' WITH GRANT OPTION;)

Bellow  configuration i am follwing
------------------------------------------------

<property>
    <name>javax.jdo.option.ConnectionURL</name>

<value>jdbc:mysql://localhost:3306/hadoop?createDatabaseIfNotExist=3Dtrue</value>
</property>
<property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>hadoop</value>
</property>
<property>
   <name>javax.jdo.option.ConnectionPassword</name>
   <value>hadoop</value>

</property>
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

<html><head><meta content=3D"text/html; charset=3Dutf-8" http-equiv=3D"Content-Type"></head><body><div><div style=3D"font-family: Calibri,sans-serif; font-size: 11pt;">When you run a hive command like show tables or show databases, do you see any errors ?<br><br>If yes, can you paste those ?<br><br>Viral<br></div></div><hr><span style=3D"font-family: Tahoma,sans-serif; font-size: 10pt; font-weight: bold;">From: </span><span style=3D"font-family: Tahoma,sans-serif; font-size: 10pt;">samir das mohapatra</span><br><span style=3D"font-family: Tahoma,sans-serif; font-size: 10pt; font-weight: bold;">Sent: </span><span style=3D"font-family: Tahoma,sans-serif; font-size: 10pt;">2/7/2013 2:47 AM</span><br><span style=3D"font-family: Tahoma,sans-serif; font-size: 10pt; font-weight: bold;">To: </span><span style=3D"font-family: Tahoma,sans-serif; font-size: 10pt;">[EMAIL PROTECTED]; [EMAIL PROTECTED]</span><br><span style=3D"font-family: Tahoma,sans-serif; font-size: 10pt; font-weight: bold;">Subject: </span><span style=3D"font-family: Tahoma,sans-serif; font-size: 10pt;">"Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"</span><br><br></body></html><div dir=3D"ltr"><div><div><div><div><div><div>Hi All,<br></div>=C2=A0 I could not see the hive meta=C2=A0 store DB under Mysql=C2=A0 database Under mysql user hadoop.<br><br></div><div>Example:<br>=C2=A0=C2=A0=20

<div style=3D"margin-top:19.2pt;margin-bottom:0pt;margin-left:0.26in;text-align:left;direction:ltr;vertical-align:baseline"><span style=3D"font-size:16pt"><span style=3D"color:rgb(18,9,137);font-family:Webdings"></span></span><font size=3D"1"><span style=3D"font-family:Arial;color:black;font-weight:normal">$>=C2=A0 mysql</span><span style=3D"font-family:Arial;color:black;font-weight:normal"> =E2=80=93u root -p</span></font></div>
<font size=3D"1">

</font><div style=3D"margin-top:19.2pt;margin-bottom:0pt;margin-left:0.26in;text-align:left;direction:ltr;vertical-align:baseline"><font size=3D"1"><span><span style=3D"color:rgb(18,9,137);font-family:Webdings">$> </span></span><span style=3D"font-family:Arial;color:black;font-weight:normal">Add
</span><span style=3D"font-family:Arial;color:black;font-weight:normal">hadoop</span><span style=3D"font-family:Arial;color:black;font-weight:normal"> user (CREATE USER =E2=80=98</span><span style=3D"font-family:Arial;color:black;font-weight:normal">hadoop'@'localhost</span><span style=3D"font-family:Arial;color:black;font-weight:normal">' IDENTIFIED BY =E2=80=98</span><span style=3D"font-family:Arial;color:black;font-weight:normal">hadoop</span><span style=3D"font-family:Arial;color:black;font-weight:normal">';)</span></font></div>
<font size=3D"1">

</font><div style=3D"margin-top:19.2pt;margin-bottom:0pt;margin-left:0.26in;text-align:left;direction:ltr;vertical-align:baseline"><font size=3D"1"><span style=3D"font-family:Arial;color:black;font-weight:normal"></span></font><font size=3D"1"><span><span style=3D"color:rgb(18,9,137);font-family:Webdings">$></span></span></font><font size=3D"1"><span style=3D"font-family:Arial;color:black;font-weight:normal">GRANT
ALL ON *.* TO =E2=80=98</span><span style=3D"font-family:Arial;color:black;font-weight:normal">hadoop</span><span style=3D"font-family:Arial;color:black;font-weight:normal">'@=E2=80=98% IDENTIFIED BY =E2=80=98</span><span style=3D"font-family:Arial;color:black;font-weight:normal">hadoop</span><span style=3D"font-family:Arial;color:black;font-weight:normal">=E2=80=99</span></font></div>
<font size=3D"1">

</font><div style=3D"margin-top:19.2pt;margin-bottom:0pt;margin-left:0.26in;text-align:left;direction:ltr;vertical-align:baseline"><font size=3D"1"><span><span style=3D"color:rgb(18,9,137);font-family:Webdings">$> </span></span><span style=3D"font-family:Arial;color:black;font-weight:normal"></span></font><font size=3D"1"><span style=3D"font-family:Arial;color:black;font-weight:normal">Example
(GRANT ALL PRIVILEGES ON *.* TO '</span><span style=3D"font-family:Arial;color:black;font-weight:normal">hadoop</span><span style=3D"font
+
Konstantin Boudnik 2013-02-07, 23:09
+
samir das mohapatra 2013-02-07, 10:47
+
samir das mohapatra 2013-02-07, 15:20
+
samir das mohapatra 2013-02-08, 06:20
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB