You are viewing a plain text version of this content. The canonical link for it is here.
Posted to mapreduce-user@hadoop.apache.org by Viral Bajaria <vi...@gmail.com> on 2013/02/07 12:30:03 UTC
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: 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
------------------------------------------------
<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"Cont=
ent-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 data=
bases, 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; fon=
t-size: 10pt; font-weight: bold;">From: </span><span style=3D"font-family: =
Tahoma,sans-serif; font-size: 10pt;">samir das mohapatra</span><br><span st=
yle=3D"font-family: Tahoma,sans-serif; font-size: 10pt; font-weight: bold;"=
>Sent: </span><span style=3D"font-family: Tahoma,sans-serif; font-size: 10p=
t;">2/7/2013 2:47 AM</span><br><span style=3D"font-family: Tahoma,sans-seri=
f; font-size: 10pt; font-weight: bold;">To: </span><span style=3D"font-fami=
ly: Tahoma,sans-serif; font-size: 10pt;">user@hadoop.apache.org; cdh-user@c=
loudera.org</span><br><span style=3D"font-family: Tahoma,sans-serif; font-s=
ize: 10pt; font-weight: bold;">Subject: </span><span style=3D"font-family: =
Tahoma,sans-serif; font-size: 10pt;">"Hive Metastore DB Issue ( Cloudera CD=
H4.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 use=
r 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-a=
lign:left;direction:ltr;vertical-align:baseline"><span style=3D"font-size:1=
6pt"><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:blac=
k;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"><s=
pan><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">had=
oop</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:b=
lack;font-weight:normal">hadoop'@'localhost</span><span style=3D"fo=
nt-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:norma=
l">';)</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"><s=
pan style=3D"font-family:Arial;color:black;font-weight:normal"></span></fon=
t><font size=3D"1"><span><span style=3D"color:rgb(18,9,137);font-family:Web=
dings">$></span></span></font><font size=3D"1"><span style=3D"font-famil=
y: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:bla=
ck;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><s=
pan style=3D"font-family:Arial;color:black;font-weight:normal">=E2=80=99</s=
pan></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"><s=
pan><span style=3D"color:rgb(18,9,137);font-family:Webdings">$> </span><=
/span><span style=3D"font-family:Arial;color:black;font-weight:normal"></sp=
an></font><font size=3D"1"><span style=3D"font-family:Arial;color:black;fon=
t-weight:normal">Example
(GRANT ALL PRIVILEGES ON *.* TO '</span><span style=3D"font-family:Aria=
l;color:black;font-weight:normal">hadoop</span><span style=3D"font-family:A=
rial;color:black;font-weight:normal">'@'</span><span style=3D"font-=
family:Arial;color:black;font-weight:normal">localhost</span><span style=3D=
"font-family:Arial;color:black;font-weight:normal">' IDENTIFIED BY '=
;</span><span style=3D"font-family:Arial;color:black;font-weight:normal">ha=
doop</span><span style=3D"font-family:Arial;color:black;font-weight:normal"=
>' WITH GRANT OPTION;)</span></font></div>
<font size=3D"1">
</font>
</div><div><br></div>Bellow=C2=A0 configuration i am follwing<br>----------=
--------------------------------------<br><br><property><br>=C2=A0=C2=
=A0=C2=A0 <name>javax.jdo.option.ConnectionURL</name><br>=C2=A0=
=C2=A0=C2=A0 <value>jdbc:mysql://localhost:3306/hadoop?createDatabase=
IfNotExist=3Dtrue</value><br>
</property><br><property><br>=C2=A0=C2=A0=C2=A0 <name>jav=
ax.jdo.option.ConnectionDriverName</name><br>=C2=A0=C2=A0=C2=A0 <v=
alue>com.mysql.jdbc.Driver</value><br></property><br><pro=
perty><br>=C2=A0 <name>javax.jdo.option.ConnectionUserName</nam=
e><br>
=C2=A0 <value>hadoop</value><br></property><br><proper=
ty><br>=C2=A0=C2=A0 <name>javax.jdo.option.ConnectionPassword</=
name><br>=C2=A0=C2=A0 <value>hadoop</value><br><br></prop=
erty><br><br><br></div>
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.<br><br><br></div>Any suggestiong..................=
........<br>
<br></div>Regrads,<br></div>samir.<br></div>
--bcaec502d692f132a604d5202931--
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with
Posted by Konstantin Boudnik <co...@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
> ------------------------------------------------
>
> <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"Cont=
> ent-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 data=
> bases, 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; fon=
> t-size: 10pt; font-weight: bold;">From: </span><span style=3D"font-family: =
> Tahoma,sans-serif; font-size: 10pt;">samir das mohapatra</span><br><span st=
> yle=3D"font-family: Tahoma,sans-serif; font-size: 10pt; font-weight: bold;"=
> >Sent: </span><span style=3D"font-family: Tahoma,sans-serif; font-size: 10p=
> t;">2/7/2013 2:47 AM</span><br><span style=3D"font-family: Tahoma,sans-seri=
> f; font-size: 10pt; font-weight: bold;">To: </span><span style=3D"font-fami=
> ly: Tahoma,sans-serif; font-size: 10pt;">user@hadoop.apache.org; cdh-user@c=
> loudera.org</span><br><span style=3D"font-family: Tahoma,sans-serif; font-s=
> ize: 10pt; font-weight: bold;">Subject: </span><span style=3D"font-family: =
> Tahoma,sans-serif; font-size: 10pt;">"Hive Metastore DB Issue ( Cloudera CD=
> H4.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 use=
> r 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-a=
> lign:left;direction:ltr;vertical-align:baseline"><span style=3D"font-size:1=
> 6pt"><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:blac=
> k;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"><s=
> pan><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">had=
> oop</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:b=
> lack;font-weight:normal">hadoop'@'localhost</span><span style=3D"fo=
> nt-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:norma=
> l">';)</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"><s=
> pan style=3D"font-family:Arial;color:black;font-weight:normal"></span></fon=
> t><font size=3D"1"><span><span style=3D"color:rgb(18,9,137);font-family:Web=
> dings">$></span></span></font><font size=3D"1"><span style=3D"font-famil=
> y: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:bla=
> ck;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><s=
> pan style=3D"font-family:Arial;color:black;font-weight:normal">=E2=80=99</s=
> pan></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"><s=
> pan><span style=3D"color:rgb(18,9,137);font-family:Webdings">$> </span><=
> /span><span style=3D"font-family:Arial;color:black;font-weight:normal"></sp=
> an></font><font size=3D"1"><span style=3D"font-family:Arial;color:black;fon=
> t-weight:normal">Example
> (GRANT ALL PRIVILEGES ON *.* TO '</span><span style=3D"font-family:Aria=
> l;color:black;font-weight:normal">hadoop</span><span style=3D"font-family:A=
> rial;color:black;font-weight:normal">'@'</span><span style=3D"font-=
> family:Arial;color:black;font-weight:normal">localhost</span><span style=3D=
> "font-family:Arial;color:black;font-weight:normal">' IDENTIFIED BY '=
> ;</span><span style=3D"font-family:Arial;color:black;font-weight:normal">ha=
> doop</span><span style=3D"font-family:Arial;color:black;font-weight:normal"=
> >' WITH GRANT OPTION;)</span></font></div>
> <font size=3D"1">
>
> </font>
>
> </div><div><br></div>Bellow=C2=A0 configuration i am follwing<br>----------=
> --------------------------------------<br><br><property><br>=C2=A0=C2=
> =A0=C2=A0 <name>javax.jdo.option.ConnectionURL</name><br>=C2=A0=
> =C2=A0=C2=A0 <value>jdbc:mysql://localhost:3306/hadoop?createDatabase=
> IfNotExist=3Dtrue</value><br>
> </property><br><property><br>=C2=A0=C2=A0=C2=A0 <name>jav=
> ax.jdo.option.ConnectionDriverName</name><br>=C2=A0=C2=A0=C2=A0 <v=
> alue>com.mysql.jdbc.Driver</value><br></property><br><pro=
> perty><br>=C2=A0 <name>javax.jdo.option.ConnectionUserName</nam=
> e><br>
> =C2=A0 <value>hadoop</value><br></property><br><proper=
> ty><br>=C2=A0=C2=A0 <name>javax.jdo.option.ConnectionPassword</=
> name><br>=C2=A0=C2=A0 <value>hadoop</value><br><br></prop=
> erty><br><br><br></div>
> 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.<br><br><br></div>Any suggestiong..................=
> ........<br>
> <br></div>Regrads,<br></div>samir.<br></div>
>
> --bcaec502d692f132a604d5202931--
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with
Posted by Konstantin Boudnik <co...@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
> ------------------------------------------------
>
> <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"Cont=
> ent-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 data=
> bases, 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; fon=
> t-size: 10pt; font-weight: bold;">From: </span><span style=3D"font-family: =
> Tahoma,sans-serif; font-size: 10pt;">samir das mohapatra</span><br><span st=
> yle=3D"font-family: Tahoma,sans-serif; font-size: 10pt; font-weight: bold;"=
> >Sent: </span><span style=3D"font-family: Tahoma,sans-serif; font-size: 10p=
> t;">2/7/2013 2:47 AM</span><br><span style=3D"font-family: Tahoma,sans-seri=
> f; font-size: 10pt; font-weight: bold;">To: </span><span style=3D"font-fami=
> ly: Tahoma,sans-serif; font-size: 10pt;">user@hadoop.apache.org; cdh-user@c=
> loudera.org</span><br><span style=3D"font-family: Tahoma,sans-serif; font-s=
> ize: 10pt; font-weight: bold;">Subject: </span><span style=3D"font-family: =
> Tahoma,sans-serif; font-size: 10pt;">"Hive Metastore DB Issue ( Cloudera CD=
> H4.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 use=
> r 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-a=
> lign:left;direction:ltr;vertical-align:baseline"><span style=3D"font-size:1=
> 6pt"><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:blac=
> k;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"><s=
> pan><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">had=
> oop</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:b=
> lack;font-weight:normal">hadoop'@'localhost</span><span style=3D"fo=
> nt-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:norma=
> l">';)</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"><s=
> pan style=3D"font-family:Arial;color:black;font-weight:normal"></span></fon=
> t><font size=3D"1"><span><span style=3D"color:rgb(18,9,137);font-family:Web=
> dings">$></span></span></font><font size=3D"1"><span style=3D"font-famil=
> y: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:bla=
> ck;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><s=
> pan style=3D"font-family:Arial;color:black;font-weight:normal">=E2=80=99</s=
> pan></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"><s=
> pan><span style=3D"color:rgb(18,9,137);font-family:Webdings">$> </span><=
> /span><span style=3D"font-family:Arial;color:black;font-weight:normal"></sp=
> an></font><font size=3D"1"><span style=3D"font-family:Arial;color:black;fon=
> t-weight:normal">Example
> (GRANT ALL PRIVILEGES ON *.* TO '</span><span style=3D"font-family:Aria=
> l;color:black;font-weight:normal">hadoop</span><span style=3D"font-family:A=
> rial;color:black;font-weight:normal">'@'</span><span style=3D"font-=
> family:Arial;color:black;font-weight:normal">localhost</span><span style=3D=
> "font-family:Arial;color:black;font-weight:normal">' IDENTIFIED BY '=
> ;</span><span style=3D"font-family:Arial;color:black;font-weight:normal">ha=
> doop</span><span style=3D"font-family:Arial;color:black;font-weight:normal"=
> >' WITH GRANT OPTION;)</span></font></div>
> <font size=3D"1">
>
> </font>
>
> </div><div><br></div>Bellow=C2=A0 configuration i am follwing<br>----------=
> --------------------------------------<br><br><property><br>=C2=A0=C2=
> =A0=C2=A0 <name>javax.jdo.option.ConnectionURL</name><br>=C2=A0=
> =C2=A0=C2=A0 <value>jdbc:mysql://localhost:3306/hadoop?createDatabase=
> IfNotExist=3Dtrue</value><br>
> </property><br><property><br>=C2=A0=C2=A0=C2=A0 <name>jav=
> ax.jdo.option.ConnectionDriverName</name><br>=C2=A0=C2=A0=C2=A0 <v=
> alue>com.mysql.jdbc.Driver</value><br></property><br><pro=
> perty><br>=C2=A0 <name>javax.jdo.option.ConnectionUserName</nam=
> e><br>
> =C2=A0 <value>hadoop</value><br></property><br><proper=
> ty><br>=C2=A0=C2=A0 <name>javax.jdo.option.ConnectionPassword</=
> name><br>=C2=A0=C2=A0 <value>hadoop</value><br><br></prop=
> erty><br><br><br></div>
> 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.<br><br><br></div>Any suggestiong..................=
> ........<br>
> <br></div>Regrads,<br></div>samir.<br></div>
>
> --bcaec502d692f132a604d5202931--
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with
Posted by Konstantin Boudnik <co...@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
> ------------------------------------------------
>
> <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"Cont=
> ent-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 data=
> bases, 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; fon=
> t-size: 10pt; font-weight: bold;">From: </span><span style=3D"font-family: =
> Tahoma,sans-serif; font-size: 10pt;">samir das mohapatra</span><br><span st=
> yle=3D"font-family: Tahoma,sans-serif; font-size: 10pt; font-weight: bold;"=
> >Sent: </span><span style=3D"font-family: Tahoma,sans-serif; font-size: 10p=
> t;">2/7/2013 2:47 AM</span><br><span style=3D"font-family: Tahoma,sans-seri=
> f; font-size: 10pt; font-weight: bold;">To: </span><span style=3D"font-fami=
> ly: Tahoma,sans-serif; font-size: 10pt;">user@hadoop.apache.org; cdh-user@c=
> loudera.org</span><br><span style=3D"font-family: Tahoma,sans-serif; font-s=
> ize: 10pt; font-weight: bold;">Subject: </span><span style=3D"font-family: =
> Tahoma,sans-serif; font-size: 10pt;">"Hive Metastore DB Issue ( Cloudera CD=
> H4.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 use=
> r 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-a=
> lign:left;direction:ltr;vertical-align:baseline"><span style=3D"font-size:1=
> 6pt"><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:blac=
> k;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"><s=
> pan><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">had=
> oop</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:b=
> lack;font-weight:normal">hadoop'@'localhost</span><span style=3D"fo=
> nt-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:norma=
> l">';)</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"><s=
> pan style=3D"font-family:Arial;color:black;font-weight:normal"></span></fon=
> t><font size=3D"1"><span><span style=3D"color:rgb(18,9,137);font-family:Web=
> dings">$></span></span></font><font size=3D"1"><span style=3D"font-famil=
> y: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:bla=
> ck;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><s=
> pan style=3D"font-family:Arial;color:black;font-weight:normal">=E2=80=99</s=
> pan></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"><s=
> pan><span style=3D"color:rgb(18,9,137);font-family:Webdings">$> </span><=
> /span><span style=3D"font-family:Arial;color:black;font-weight:normal"></sp=
> an></font><font size=3D"1"><span style=3D"font-family:Arial;color:black;fon=
> t-weight:normal">Example
> (GRANT ALL PRIVILEGES ON *.* TO '</span><span style=3D"font-family:Aria=
> l;color:black;font-weight:normal">hadoop</span><span style=3D"font-family:A=
> rial;color:black;font-weight:normal">'@'</span><span style=3D"font-=
> family:Arial;color:black;font-weight:normal">localhost</span><span style=3D=
> "font-family:Arial;color:black;font-weight:normal">' IDENTIFIED BY '=
> ;</span><span style=3D"font-family:Arial;color:black;font-weight:normal">ha=
> doop</span><span style=3D"font-family:Arial;color:black;font-weight:normal"=
> >' WITH GRANT OPTION;)</span></font></div>
> <font size=3D"1">
>
> </font>
>
> </div><div><br></div>Bellow=C2=A0 configuration i am follwing<br>----------=
> --------------------------------------<br><br><property><br>=C2=A0=C2=
> =A0=C2=A0 <name>javax.jdo.option.ConnectionURL</name><br>=C2=A0=
> =C2=A0=C2=A0 <value>jdbc:mysql://localhost:3306/hadoop?createDatabase=
> IfNotExist=3Dtrue</value><br>
> </property><br><property><br>=C2=A0=C2=A0=C2=A0 <name>jav=
> ax.jdo.option.ConnectionDriverName</name><br>=C2=A0=C2=A0=C2=A0 <v=
> alue>com.mysql.jdbc.Driver</value><br></property><br><pro=
> perty><br>=C2=A0 <name>javax.jdo.option.ConnectionUserName</nam=
> e><br>
> =C2=A0 <value>hadoop</value><br></property><br><proper=
> ty><br>=C2=A0=C2=A0 <name>javax.jdo.option.ConnectionPassword</=
> name><br>=C2=A0=C2=A0 <value>hadoop</value><br><br></prop=
> erty><br><br><br></div>
> 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.<br><br><br></div>Any suggestiong..................=
> ........<br>
> <br></div>Regrads,<br></div>samir.<br></div>
>
> --bcaec502d692f132a604d5202931--
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with
Posted by Konstantin Boudnik <co...@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
> ------------------------------------------------
>
> <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"Cont=
> ent-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 data=
> bases, 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; fon=
> t-size: 10pt; font-weight: bold;">From: </span><span style=3D"font-family: =
> Tahoma,sans-serif; font-size: 10pt;">samir das mohapatra</span><br><span st=
> yle=3D"font-family: Tahoma,sans-serif; font-size: 10pt; font-weight: bold;"=
> >Sent: </span><span style=3D"font-family: Tahoma,sans-serif; font-size: 10p=
> t;">2/7/2013 2:47 AM</span><br><span style=3D"font-family: Tahoma,sans-seri=
> f; font-size: 10pt; font-weight: bold;">To: </span><span style=3D"font-fami=
> ly: Tahoma,sans-serif; font-size: 10pt;">user@hadoop.apache.org; cdh-user@c=
> loudera.org</span><br><span style=3D"font-family: Tahoma,sans-serif; font-s=
> ize: 10pt; font-weight: bold;">Subject: </span><span style=3D"font-family: =
> Tahoma,sans-serif; font-size: 10pt;">"Hive Metastore DB Issue ( Cloudera CD=
> H4.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 use=
> r 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-a=
> lign:left;direction:ltr;vertical-align:baseline"><span style=3D"font-size:1=
> 6pt"><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:blac=
> k;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"><s=
> pan><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">had=
> oop</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:b=
> lack;font-weight:normal">hadoop'@'localhost</span><span style=3D"fo=
> nt-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:norma=
> l">';)</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"><s=
> pan style=3D"font-family:Arial;color:black;font-weight:normal"></span></fon=
> t><font size=3D"1"><span><span style=3D"color:rgb(18,9,137);font-family:Web=
> dings">$></span></span></font><font size=3D"1"><span style=3D"font-famil=
> y: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:bla=
> ck;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><s=
> pan style=3D"font-family:Arial;color:black;font-weight:normal">=E2=80=99</s=
> pan></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"><s=
> pan><span style=3D"color:rgb(18,9,137);font-family:Webdings">$> </span><=
> /span><span style=3D"font-family:Arial;color:black;font-weight:normal"></sp=
> an></font><font size=3D"1"><span style=3D"font-family:Arial;color:black;fon=
> t-weight:normal">Example
> (GRANT ALL PRIVILEGES ON *.* TO '</span><span style=3D"font-family:Aria=
> l;color:black;font-weight:normal">hadoop</span><span style=3D"font-family:A=
> rial;color:black;font-weight:normal">'@'</span><span style=3D"font-=
> family:Arial;color:black;font-weight:normal">localhost</span><span style=3D=
> "font-family:Arial;color:black;font-weight:normal">' IDENTIFIED BY '=
> ;</span><span style=3D"font-family:Arial;color:black;font-weight:normal">ha=
> doop</span><span style=3D"font-family:Arial;color:black;font-weight:normal"=
> >' WITH GRANT OPTION;)</span></font></div>
> <font size=3D"1">
>
> </font>
>
> </div><div><br></div>Bellow=C2=A0 configuration i am follwing<br>----------=
> --------------------------------------<br><br><property><br>=C2=A0=C2=
> =A0=C2=A0 <name>javax.jdo.option.ConnectionURL</name><br>=C2=A0=
> =C2=A0=C2=A0 <value>jdbc:mysql://localhost:3306/hadoop?createDatabase=
> IfNotExist=3Dtrue</value><br>
> </property><br><property><br>=C2=A0=C2=A0=C2=A0 <name>jav=
> ax.jdo.option.ConnectionDriverName</name><br>=C2=A0=C2=A0=C2=A0 <v=
> alue>com.mysql.jdbc.Driver</value><br></property><br><pro=
> perty><br>=C2=A0 <name>javax.jdo.option.ConnectionUserName</nam=
> e><br>
> =C2=A0 <value>hadoop</value><br></property><br><proper=
> ty><br>=C2=A0=C2=A0 <name>javax.jdo.option.ConnectionPassword</=
> name><br>=C2=A0=C2=A0 <value>hadoop</value><br><br></prop=
> erty><br><br><br></div>
> 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.<br><br><br></div>Any suggestiong..................=
> ........<br>
> <br></div>Regrads,<br></div>samir.<br></div>
>
> --bcaec502d692f132a604d5202931--