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: [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=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;">[email protected]; 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--
