You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-user@hadoop.apache.org by samir das mohapatra <sa...@gmail.com> on 2013/02/07 11:47:05 UTC
"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 –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 hive-0.9.0-cdh4.1.2)"
Posted by samir das mohapatra <sa...@gmail.com>.
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 <su...@hortonworks.com>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 <
> samir.helpdoc@gmail.com> wrote:
>
>> Any Suggestion...................
>>
>>
>> On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <
>> samir.helpdoc@gmail.com> 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/
>
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Posted by samir das mohapatra <sa...@gmail.com>.
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 <su...@hortonworks.com>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 <
> samir.helpdoc@gmail.com> wrote:
>
>> Any Suggestion...................
>>
>>
>> On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <
>> samir.helpdoc@gmail.com> 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/
>
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Posted by samir das mohapatra <sa...@gmail.com>.
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 <su...@hortonworks.com>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 <
> samir.helpdoc@gmail.com> wrote:
>
>> Any Suggestion...................
>>
>>
>> On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <
>> samir.helpdoc@gmail.com> 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/
>
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Posted by samir das mohapatra <sa...@gmail.com>.
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 <su...@hortonworks.com>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 <
> samir.helpdoc@gmail.com> wrote:
>
>> Any Suggestion...................
>>
>>
>> On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <
>> samir.helpdoc@gmail.com> 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/
>
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Posted by Suresh Srinivas <su...@hortonworks.com>.
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 <samir.helpdoc@gmail.com
> wrote:
> Any Suggestion...................
>
>
> On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <
> samir.helpdoc@gmail.com> 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/
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Posted by Suresh Srinivas <su...@hortonworks.com>.
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 <samir.helpdoc@gmail.com
> wrote:
> Any Suggestion...................
>
>
> On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <
> samir.helpdoc@gmail.com> 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/
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Posted by Suresh Srinivas <su...@hortonworks.com>.
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 <samir.helpdoc@gmail.com
> wrote:
> Any Suggestion...................
>
>
> On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <
> samir.helpdoc@gmail.com> 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/
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Posted by Suresh Srinivas <su...@hortonworks.com>.
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 <samir.helpdoc@gmail.com
> wrote:
> Any Suggestion...................
>
>
> On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <
> samir.helpdoc@gmail.com> 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/
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Posted by samir das mohapatra <sa...@gmail.com>.
Any Suggestion...................
On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <samir.helpdoc@gmail.com
> 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 hive-0.9.0-cdh4.1.2)"
Posted by samir das mohapatra <sa...@gmail.com>.
Any Suggestion...................
On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <samir.helpdoc@gmail.com
> 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 hive-0.9.0-cdh4.1.2)"
Posted by samir das mohapatra <sa...@gmail.com>.
Any Suggestion...................
On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <samir.helpdoc@gmail.com
> 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 hive-0.9.0-cdh4.1.2)"
Posted by samir das mohapatra <sa...@gmail.com>.
Any Suggestion...................
On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra <samir.helpdoc@gmail.com
> 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.
>