hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suresh Srinivas <sur...@hortonworks.com>
Subject Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Date Thu, 07 Feb 2013 22:01:23 GMT
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/

Mime
View raw message