Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
HDFS, mail # user - Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"


Copy link to this message
-
Re: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with hive-0.9.0-cdh4.1.2)"
Suresh Srinivas 2013-02-07, 22:01
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/