MapReduce, mail # user - "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"

"Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"

samir das mohapatra 2013-02-07, 10:47

Hi All,
  I could not see the hive meta store DB under Mysql database Under mysql
user hadoop.

Example:

$> mysql –u root -p
$> Add hadoop user (CREATE USER ‘hadoop'@'localhost' IDENTIFIED BY ‘hadoop
';)
$>GRANT ALL ON *.* TO ‘hadoop'@‘% IDENTIFIED BY ‘hadoop’
$> 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=true</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.

RE: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with

Viral Bajaria 2013-02-07, 11:30

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

Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"

samir das mohapatra 2013-02-07, 15:20

Any Suggestion...................
On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <[EMAIL PROTECTED]
> wrote:

> Hi All,
> I could not see the hive meta store DB under Mysql database Under
> mysql user hadoop.
>
> Example:
>
> $> mysql –u root -p
> $> Add hadoop user (CREATE USER ‘hadoop'@'localhost' IDENTIFIED BY ‘
> hadoop';)
> $>GRANT ALL ON *.* TO ‘hadoop'@‘% IDENTIFIED BY ‘hadoop’
> $> 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=true</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.
>

Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with

Konstantin Boudnik 2013-02-07, 23:09

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>

Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"

samir das mohapatra 2013-02-08, 06:20

Hi Suresh,
Thanks for advice,

why you are so monopoly, You shoul not be. Problem is solution not
problem.

Note: I am looking for any user does not matter bcz it is common use
Scenario.
On Fri, Feb 8, 2013 at 3:31 AM, Suresh Srinivas <[EMAIL PROTECTED]>wrote:

> Please only use CDH mailing list and do not copy this to hdfs-user.
>
>
> On Thu, Feb 7, 2013 at 7:20 AM, samir das mohapatra <
> [EMAIL PROTECTED]> wrote:
>
>> Any Suggestion...................
>>
>>
>> On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <
>> [EMAIL PROTECTED]> wrote:
>>
>>> Hi All,
>>> I could not see the hive meta store DB under Mysql database Under
>>> mysql user hadoop.
>>>
>>> Example:
>>>
>>> $> mysql –u root -p
>>> $> Add hadoop user (CREATE USER ‘hadoop'@'localhost' IDENTIFIED BY ‘
>>> hadoop';)
>>> $>GRANT ALL ON *.* TO ‘hadoop'@‘% IDENTIFIED BY ‘hadoop’
>>> $> 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=true</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.
>>>
>>
>>
>
>
> --
> http://hortonworks.com/download/
>