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

Switch to Plain View
MapReduce >> mail # user >> RE: "Hive Metastore DB Issue ( Cloudera CDH4.1.2 MRv1 with


+
Viral Bajaria 2013-02-07, 11:30
+
Konstantin Boudnik 2013-02-07, 23:09
Copy link to this message
-
"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.
+
samir das mohapatra 2013-02-07, 15:20
+
samir das mohapatra 2013-02-08, 06:20