Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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)"
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/
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB