-
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/
>
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/
>
