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


+
Viral Bajaria 2013-02-07, 11:30
Copy link to this message
-
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with
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>
+
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